April 1, 2011 at 7:54 am
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
April 2, 2011 at 2:45 pm
if all the instances are registered under a SQL Server 2008 central management instance use the following query to add the group and assign sysadmin privileges
CREATE LOGIN [domain\group] FROM WINDOWS
EXEC sp_addsrvrolemember 'domain\group', 'sysadmin'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 6:43 am
Hi,
Thank you for reply.
I have around 50 server & around 200 Instance's. You mean i have to login every server and run that syntax or ? Did i miss anything.
Note: No 3rd party tools here.
Thanks again.
New DB
April 4, 2011 at 8:09 am
M.Kahn (4/4/2011)
You mean i have to login every server and run that syntax or
Yes, pretty much or alternatively
As i said if you have SQL Server 2008 central management server available you may execute a script across all instances registered underneath it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply