• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

SQL2008 sysadmin and AD Groups

SimonMac

TykeLike
Joined
Aug 27, 2010
Messages
24,897
Likes received
5,244
Thanks received
1,850
Location
God's Own Republic Of Yorkshire
I am not a SQL guy by day but being roped in due to lack of other options.

At the moment the only sysadmin is a user who has left the organisation, I would like to have an AD Group be a sysadmin so anyone in that group get the permissions, firstly is this possible or can only specific logins be added to the sysadmin server role?

If possible I assume I have to add the AD group as a Logins and then assign this to the Server Role? This is only a dev box so its not the end of the world if I cock things up massively :laugh
 

Advertisers

Back
Top