September 16, 2004 at 8:12 am
I'm trying to run a script to check to see if all of the SQL Server passwords are strong and I found that on one server I had two sa entries in the sysxlogins table. Is this normal? I wasn't able to find much information about this table.
Thank you.
September 16, 2004 at 8:38 am
That is because you have linked server setup and use 'sa' as remote login.
September 16, 2004 at 8:44 am
Thank you. I'm in the process of trying to lockdown the sa account (under considerable protest from many around me).
September 17, 2004 at 12:25 pm
Do you of a script to find out the password of the sa login? I inherited a SQL server using the sa account for some of the dbs and the sa password isn't documented. Please let me know. Thanks!
September 20, 2004 at 6:28 am
There is a script by Joseph Gama which should help you:
http://www.sqlservercentral.com/columnists/jgama/sqlserverpasswordauditing.asp
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply