Post reply

When sql login was disabled

  • May 11, 2017 at 10:09 am

    #325582

    Hi,

    Can we track by any chance if the sql login account or windows was disabled or locked. Presently I see that its not locked. But would like to check if we have any repository to check and find that out.

    T

    Thanks.

  • May 11, 2017 at 11:12 am

    #1942196

    SQL-DBA-01 - Thursday, May 11, 2017 10:09 AM

    Hi,

    Can we track by any chance if the sql login account or windows was disabled or locked. Presently I see that its not locked. But would like to check if we have any repository to check and find that out.

    T

    From the SQL Server perspective, you can't track the status unless you set something up in advance to audit the status.
    You can check the current status of the logins by querying sys.server_principals:
    SELECT name, LOGINPROPERTY(name, 'IsLocked') as is_locked,is_disabled
    FROM sys.server_principals

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply