What is the best way to change passwords
-
I have users that use SQL Server Authentication. They are at a remote facility and I would like to give them the ability to change their password and only their password. They do not have Enterprise Manager/Query Analyzer.
What is the best method for them to change their password?
-SQLBill
-
I would create a small app that connects to SQL Server using their credentials and then have the app call sp_password to make the change. This way they will be able to change only their password.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB EngineerThis posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
-
Thanks. I was thinking about using OSQL and sp_password. But now I'm considering creating a form in MS Access.
-SQLBill
-
I use an Access program and run this command against the SQL Server:
strSQL = "sp_password NULL, '" & Me!txtPassword.Value & "', '" & strSQLUserName & "'"
Set cmd = New ADODB.Command
With cmd
.ActiveConnection = conn
.CommandType = adCmdText
.CommandText = strSQL
End With
cmd.Execute
Set cmd = Nothing
sp_password is in the master database.
-
I'd use an ASP page. Take the old and new, submit both to sp_password and get the success or failure.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
I've never used ASP, where can I find information on how to set up an ASP page?
-SQLBill
-
Hi SQLBill
quote:
I've never used ASP, where can I find information on how to set up an ASP page?
for ASp is just a kind of VB that runs within a browser, you might take a look at some ASP Websites like
If this doesn't help, post again and we'll figure this out
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanks everyone.
I have some ideas now. I'm not sure ASP will work for me, I'll have to check into it more. I'm not allowed to use 'unapproved' software, so I need to find out exactly what ASP is. I'll check out the sites Frank posted. I'm also looking into testing Access since all my users have that.
-SQLBill
-
ASP = Active Server Pages
It's a scripting environment for IIS (started in 3.0, I believe). Try this for a resource:
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
Hi SQLBill,
quote:
I have some ideas now. I'm not sure ASP will work for me, I'll have to check into it more. I'm not allowed to use 'unapproved' software, so I need to find out exactly what ASP is. I'll check out the sites Frank posted. I'm also looking into testing Access since all my users have that.
since all your user have Access, I think this is the least common denominator and I think you get quicker a working result with it. Not that ASP programming is difficult, but a little bit different.
However, Access examples you can find here
http://www.uaex.edu/bknox/ms_access_logon.htm (there is a downloadable 2000 db)
http://www.gj.thorpe.btinternet.co.uk/login.htm (this one might be even better)
HTH
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply