November 23, 2011 at 9:39 am
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
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
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy