Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was.

SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: The password of the account must be changed. (Microsoft SQL Server, Error: 18488)

So, how can I reset my password?

I tried terminaling into the server with this account, but it said that account doesn't exist. So I guess it's not a regular server account--just SQL server. (if that helps)

share|improve this question

3 Answers 3

up vote 3 down vote accepted

If SSMS isn't prompting you to change your password, have the DBA remove the change password requirement, and give you instructions on how to change your password via the sp_password system stored procedure.

share|improve this answer
    
The DBA removed the change-password requirement, and I was able to login. –  Bill Paetzke Sep 22 '09 at 21:03

Looks like a Windows password policy has been enforced in SQL Server: http://msdn.microsoft.com/en-us/library/ms161959.aspx.

If this is a SQL Server internal login (as opposed to a Windows one), there's nothing you can do about that; only a DB administrator can reset passwords for SQL Server users.

share|improve this answer

Actually you can change it via SSMS. Right Click on the Server under the registered tab and Select New Query. This should prompt you to change your Password. Why it won't do it when you try to connect to the Object explorer is one of those Microsoft mysteries.

Imran

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.