how to identify whether my sa account is disabled in sql server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » how to identify whether my sa account is...

how to identify whether my sa account is disabled in sql server

Rate Topic

Display Mode

Topic Options

Author

Message

draj108

Posted Thursday, February 18, 2010 4:45 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 15, 2012 4:29 AM
Points: 48, Visits: 195

Hi All,

how to identify whether my sa account is disabled in sql server. Is there any system sp or anything?

Thanks,
DR

Post #867900

sql_lock

Posted Thursday, February 18, 2010 4:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 1,289, Visits: 1,533

Within SSMS you will see a "red" down arrow.

Post #867904

draj108

Posted Thursday, February 18, 2010 5:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 15, 2012 4:29 AM
Points: 48, Visits: 195

Thanks for the replay.

But I could not see that in SSMS 2000.

However what is way to enable it? I am having a prod sql server 2000 with SP4.

Thanks,
DR

Post #867909

sql_lock

Posted Thursday, February 18, 2010 5:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 1,289, Visits: 1,533

You have added the post to SQL 2005... Not there in SQL2k

Try ..

SELECT * FROM syslogins

From my memory i think there is a is_disabled column

Post #867915

« Prev Topic | Next Topic »

Permissions