InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 02:15:26 GMT20http://www.sqlservercentral.com/Forums/Topic962960-359-1.aspxAre you using a local instance here? The server OS matters here. I don't believe this works on workstation OSes or pre-W2K3. It does work on my local Win 7 instance. In SSMS I get the change pwd dialog.You can do this through T-SQL, but you still have to log in for it to work. I'm not sure it works in Shared Memory, though it should.Tue, 03 Aug 2010 11:21:26 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic962960-359-1.aspxI'm sorry I meant SSMS. That's what we have. I created a user and then checked the box that says user much change password at next login. Then I logged back into SSMS with the user and when I try to log in I received an error message that says: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233).How can I have users change their password at the next login...if they can't log in.Is there some way to do it through the application?Tue, 03 Aug 2010 11:12:09 GMTNew_to_being_DBAhttp://www.sqlservercentral.com/Forums/Topic962960-359-1.aspxEnterprise Manager would be too old. It uses an older client technology. SSMS should pop up a dialog.The client receives a message, and then should display a dialog. It's possible that some older clients might not be able to handle it.Tue, 03 Aug 2010 10:56:23 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic962960-359-1.aspxI know about the checkbox. But if the checkbox is checked (that you must change password at next login)...how do you change password at next login? I tried it from Enterprise manager and received an error message? Is their a third party tool? Do you change it through an application front end that uses SQL as the backend?Tue, 03 Aug 2010 10:49:01 GMTNew_to_being_DBAhttp://www.sqlservercentral.com/Forums/Topic962960-359-1.aspxThere's a checkbox if you are on W2K3 and later[url]http://msdn.microsoft.com/en-us/library/ms161959.aspx[/url]Tue, 03 Aug 2010 10:27:29 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic962960-359-1.aspxWe are setting up a new system that uses IBM relational system architect. I want to create users with sql server logins and have them change their password at next login. how does the user change their password at next login? Tue, 03 Aug 2010 10:10:39 GMTNew_to_being_DBA