Find out sa password

[rzirpolo]

The Enterprise Manager I am using was configured by someone else and in the registration properties of the connection to the Server the login is sa.

So I can login as sa, once I am logged in as sa is there anyway I can find out the password ?

 

[RobertT687]

You cannot find out the password, however as 'sa' you can always change the password. Be aware that this change will effect all processes that depend on the 'sa' password. As a practice I rarely use 'sa'. I create another user and grant them the appropriate roles.

 

[SQLBill]

You could try the default password (no password at all). If you have admin privileges, you can change the SA password.

-SQLBill

 

[NoCoolHandle]

Just a stupid question, but in EM if you edit the propertys of the connection, have you been able to use a trusted connection logged on as an administrator of the Domain or System?

 

[rzirpolo]

In Enterprise Manager the sa login is configured but the password is masked. I just wondered if there was an easy way of finding out what it is for future reference.

This is no biggie and changing password is not an option.

Thanks for all the feedback.

 

[SQLBill]

There isn't any way to 'retrieve' a usable password from SQL Server.

-SQLBill