changing passwords at next login?

Question

Post reply

changing passwords at next login?

New_to_being_DBA

SSCrazy

Points: 2064
More actions
August 3, 2010 at 10:10 am

#224969

We 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?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

There's a checkbox if you are on W2K3 and later

http://msdn.microsoft.com/en-us/library/ms161959.aspx

New_to_being_DBA SSCrazy Points: 2064 More actions · Answer 2

I 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?

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 3

Enterprise 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.

New_to_being_DBA SSCrazy Points: 2064 More actions · Answer 4

I'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?

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

Are 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.