May 16, 2011 at 9:57 am
In my scenario end users connect to the database from remote locations using sql server authentication and frontends like excel or access.
But when a password expires I want users to be able to change it themselves i. e. without the support of admins or using admin tools like SSMS.
Any hints on how to achieve this?
The most comfortable solution I can imagine is if the driver recognizes that the password has expired and provides a dialog to the user to change the password (like SSMS does). Is there such a driver?
A very brute solution might be to write a web application that allows the user to change the password. The user provides the application with the user id and password. The application verifies the login information in sql server. If it is correct then the user can change his password (by sending an "ALTER LOGIN" to the database under the technical account of the application that of course needs to have the proper permissions).
What would you do? Any ideas are very welcome?
May 18, 2011 at 2:18 am
No ideas on this topic?
May 18, 2011 at 3:23 am
This is IIS related.
Thanks
May 18, 2011 at 5:21 am
No, there is no IIS involved at all. I am talking about a direct (OLE DB or ODBC) database connection from a client to a server.
May 18, 2011 at 8:43 am
Sql server does not have a UI. You will have to create a way to present this to your users.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 19, 2011 at 2:33 am
OK, now at least I found that the sql server native client is capable to notice when a password is expired and shows a dialog box where the user can change his password. But it seems that this does not happen with all client software:
MS Excel (at least when using MS Query) can do this.
MS Access seemingly not.
Does this feature depend on the protocol (like ODBC/OLE DB/ADO)?
May 19, 2011 at 7:24 am
When establishing a connection if the username/password is correct but the password is set to expired sql will raise an error that the login in failed.
Login failed for user ''. Reason: The password of the account must be changed.
It sounds like Excel might have some built in error handling on opening a connection.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply