June 4, 2003 at 7:39 am
I need to reset the password for 400 users to a unique password for each user. Can this be done at the user level by prompting the user to change his/her sql server password..?
June 4, 2003 at 7:56 am
sp_password will allow people to change their password, but they need a way of running it eg isqlw, osql or an application.
Steven
June 4, 2003 at 8:00 am
quote:
sp_password will allow people to change their password, but they need a way of running it eg isqlw, osql or an application.
June 4, 2003 at 8:02 am
Thanks. I am aware of the sp_password option. However you mentioned the application. If this is the way it needs to be done. How do you integrate this into the application side where the user is prompted to change it..?
June 4, 2003 at 8:33 am
It would need to be designed into the frontend.
It may be easier (and quicker) for the dba to change all the passwords. The usernames could easily be extracted from the database, and a one off change password script written.
Steven
June 5, 2003 at 3:31 am
Develope an application to change sql user password and deploy it using group policy.
Using group policy you can deploy an application in the client system when it starts.
After deploying the application let them change the password using that application.
June 5, 2003 at 8:03 am
Curious: could your login naming convention be similar to your email naming convention? I see an interesting experiment brewing...
June 5, 2003 at 8:24 am
Curious: could your login naming convention be similar to your email naming convention? I see an interesting experiment brewing...
Our login ids are different from our email addresses.
June 5, 2003 at 9:43 am
Send them to a web page that takes their username and password into SQL Server, as well as what they want the new password to be (do the confirm password field as well). Attempt to connect to the server using the username and password given (trap for a failed connection). Then execute the sp_password. Should be fairly simple. Of course, if you have the option, make it an https link (your web administrators should know how, but it requires a certificate).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply