Post reply

2 sa

  • November 23, 2011 at 9:39 am

    #390934

    Hi,

    I am pretty confused, If we can have 2 sa on an instance in sql server 2005.

    I mean 2 logins such as sa and sa1, whcih have same privileges and all permissions of an sa..

    Is that possible.

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

  • November 23, 2011 at 9:48 am

    #1412323

    Yes. You can also have an active directory group added to the sa server role if you would like. That is a common practice and is better (imho) than creating a second account and naming it sa1.

    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

  • November 23, 2011 at 9:52 am

    #1412324

    Can it be done within the SSMS or AD ?

    Can i know the steps please.

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

  • November 23, 2011 at 9:54 am

    #1412329

    If you already have the groups or accounts created in AD, then you need only add that user to the instance through ssms. Create a login that maps to the ad group/account and then add that group/account to the server role for SA.

    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

  • November 23, 2011 at 10:41 am

    #1412361

    thanks a lot.

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 5 posts - 1 through 4 (of 4 total)

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