Friday, February 24, 2012

Cant connect via EM after changing sa password?

A client of mine changed his SA password "because it hadn't been changed in a while". :mad: Now nobody can get into Enterprise Manager - opening EM or trying to right-click > Connect on the server yields an error:

A connection could not be established to SERVER1.

Reason: login failed for user 'sa'.

Please verify SQL Server is running and check your SQL Server Registration
properties (by right-clicking on the SERVER1 node) and try again.

Of course, if I right-click on the SERVER1 node, I get the same message.

My client remembers the password he set; I managed to use it to get into Query Analyzer, which I thouhght was weird. But no luck with Enterprise Manager. It's just trying to log in as sa without prompting for a pw.

I already tried running sp_Password in Query Analyzer to change the pw back to what it was. Still can't connect to the SQL Server via Enterprise Manager.

What can I do?Did you edit the sql server registration and change the password there?

EDIT: And while I'm Here

Now nobody can get into Enterprise Manager

SCARY

Sorry Rudy|||Unclear from your post: have you tried editing the connection properties, or are you not able to get to that point?

If it won't even let you right-click on the registration to edit the properties, then try dropping the registration and creating a new one.|||Unless BUILTIN\Administrators local group is removed from SQL Server security, you can logon as a local admin or as a member of that group and easily change the SA password.

No comments:

Post a Comment