April 26, 2010 at 7:36 am
We are running SQL Server 2005 (SP3) on a SQL Server Cluster Machine which is running Windows Server 2003 R2 Enterprise x64 Edition SP2. There are multiple SQL Server 2005 Named Instances running on this machine. There are different DBAs responsible for each SQL Server 2005 Named Instance. Is there any way to ensure that a DBA may stop/start only the services for the Named Instance they are responsible for? If so, how may this be accomplished?
Thanks, Kevin
April 26, 2010 at 9:38 am
Take Offiline/Bring Online....this will restart the services with out any failover.
April 26, 2010 at 10:04 am
Ravikanth, what are you talking about bringing offline/online? I just want to stop/start the sql services for a particular Named Intance without affecting other Instances. The network group does not want to give the DBAs permissions/access because they (DBAs) would be able to stop/start services for Instances they (DBAs) are not responsible for. Can a DBA be given permissions/access to stop/start the sql services for a particular Instance? (Without having permissions/access to the other Named Instances on the machine.)
Thanks, Kevin
April 26, 2010 at 10:34 am
Assuming that each DBA uses their Network login and this network login is given sysadmin rights only on the named instances to which they have rights to admin, then they should only be able to stop/start the sql services for thoses named instances.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply