Unable to access the SQL database with sa,

[JamalNUMAN]

Unable to access the SQL database with sa,

I couldn’t figure out why I’m not able any longer to access my SQL database with sa knowing that the password is not changed and the option of expiration is not check.

I tried to access it with other user (montaser) and it works fine!

Is there any chance that the password of the sa is change accidentally?

What other issues should I consider?

Is there any way to change the password of the sa?

Thank you

Best

Jamal

[ScottDean]

Are you able to log into SQL MS with the SA account?  If so then your password is not the issue.  If not then obviously the password was changed and unless you have another account with SysAdmin then I don't think you can change it.  In the event that you cannot determine the password nor the ability to change it you can try the back door mentioned below.

SQL Server lets any member of a Local Administrators group connect to SQL Server with SYSADMIN privileges.

http://technet.microsoft.com/en-us/magazine/jj853293.aspx 

[JamalNUMAN]

Many thanks Scott,

I got a help from SQL database expert and he could resolve the issue (restoring the password of the Sa). I’m not sure which method he sued.

Now, I wanted to change the password of the sa to ensure better security but I got the message below

What might be the issue here?

[AsrujitSengupta · Accepted solution]

Uncheck those two options and try again.

[JamalNUMAN]

Thank you very much Asrujit for the help. It works like a charm

Best

Jamal

[ScottDean]

This is because the account has picked up either local or domain policies.  You can change this policy by specifying CHECK_POLICY = OFF, make the change and then turn this back on.