- 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
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
