Post reply

Logins disabled

  • July 26, 2010 at 10:55 am

    #146313

    Hi,

    When i went to SSMS-->Security-->Logins. Then I see all the logins are disabled automatically..

    How does it happen?

    Is there a way of enabling all by a script or I have to enable each by going into properties and then enabling.

    Any views?

    Thanks,

    Sushant.

    Regards
    Sushant Kumar
    MCTS,MCP

  • July 26, 2010 at 11:02 am

    #1198311

    Which logins were disabled? Ones that you created?

    Are you creating these via script or through the gui?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 26, 2010 at 11:14 am

    #1198319

    Which logins were disabled? Ones that you created?

    Are you creating these via script or through the gui?

    The server level logins...I didnt create them.

    They were made when the server was setup.

    Regards
    Sushant Kumar
    MCTS,MCP

  • July 26, 2010 at 11:31 am

    #1198330

    Any administrator can disable logins.

  • July 26, 2010 at 11:59 am

    #1198345

    I asked, nobody did it..

    Now can i enable all at 1 script or each one of them differently from GUI.

    Regards
    Sushant Kumar
    MCTS,MCP

  • July 26, 2010 at 12:09 pm

    #1198358

    If I understand correctly, the logins that are disabled are the NT Authority\System, and NT Service logins.

    This could be getting disabled by a local security policy on the server or somebody disabled them. Verify that the local group policy for the server is not disabling your logins.

    Here is an example of how to use a script to enable / disable a login.

    http://blog.sqlauthority.com/2007/05/03/sql-server-enable-login-disable-login-using-alter-logic-change-name-of-the-sa/

    One thing to consider, has somebody been playing with security hardening? Some scripts that harden security will also do this.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 26, 2010 at 1:20 pm

    #1198412

    @ cirqued

    The logins disabled are the users...For ex bre,gra,jon etc..

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 7 posts - 1 through 6 (of 6 total)

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