SQL Server Performance

Login Locked Out Tab is disabled

Discussion in 'SQL Server 2005 General DBA Questions' started by y.koteswarrao, Jul 14, 2010.

  1. y.koteswarrao New Member

    Hi,
    Iam a sysadmin,i saw that Login properties->status->"Login is Locked Out tab is showing disabled always,unable to check or uncheck the box.........
    Use SQL SERVER 2005 32bit
    If any one know please let me know
    koteswar rao

    y.koteswarrao, Jul 14, 2010
    #2

  2. ashish287 New Member

    1) is it the windows id or SQL id? If windows enable it from Active Directory or where windows account or managing.
    2) Try to create a sql test user with same permission and disable the account and enable it. It should work as long sql server loves you :)
    ashish287, Jul 14, 2010
    #3

  3. satya Moderator

    If you are using MIXED mode authentication, then you can use SA account to login and see the permissions again unless that is NOT DISABLED.
    satya, Jul 15, 2010
    #4

Share This Page