Prompting User to change SQL Password

[RemingtonSteel]

Is there a way to prompt a password so the user will be able to change their password in SQL 2005. We are using a software that uses SQL authentication instead of Windows authentication.

Thanks!
Gene

 

[MartinCroft]

All things are usually possible, there is no ability with SQL to offer a popup facility to change the password out of the box. Dependant on your requirements, you could write something that would do what you wanted, to call the password check them the application etc. At a low level you could get the users to change the passwords through Query analyser or Management studio. I don't know if your users use this or not.

There are ways you could have scheduled checks that the password does not exceed a set time and notify users, either email or net send etc. It really depends on what access they have and how you want to manage it.

 

[mrdenny]

You can enable the password change requirements within SQL which uses the Windows domain policy to decide when the password should expire. You would then have to setup your app to monitor the logon process and if an error is returned saying that the password must be changed, then prompt the user to change there password.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL BI 2005 / SQL 2008 DBA / SQL 2008 DBD / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005/2008 / BI Dev (SQL 2005)

My Blog