Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stockholmpost
Starting Member
5 Posts |
 Posted - 2011-04-01 : 10:55:47
|
Hi,I have a group in kwr-fs-dws-sqladm (ActiveDirectory-Exchage group) and there are 2 user in that. That group go to all sql server and instances. I have access to windows server 2008 as admin.My questioin, how can i add that group in all 50 sql server and 200 Instances. kwr-fs-dws-sqladm - use as sysadmin -.New in SQL-DB  |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-04-01 : 19:57:49
|
| CREATE LOGIN MyGroupName FROM WINDOWS;exec sp_AddSrvRoleMember @Loginame = 'MyGroupName', @rolename = 'sysadmin';Run this on every server.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
|
|
|
How to add new group in SQL Server 2008