SSMS 2008 R2 Start/Stop Service

• chung-wah.wong

  SSC-Addicted

  Points: 411

  More actions

  April 26, 2011 at 11:07 am

  #235229

  Taking over for previous SQL admin, and he has set up a Windows cluster with a SQL cluster as a service. Want to give access to start/stop that particular service through SSMS but it is showing as greyed out. Would rather not give them access to Failover Cluster Manager or admin rights. Is there a way to do this in SSMS 2008 R2? They are already a sysadmin to that SQL instance.

• steve Schneider

  Right there with Babe

  Points: 738

  More actions

  December 27, 2011 at 1:55 pm

  #1425860

  Actually, that is the only 'proper' way you want to allow a sql instance to be restarted...thru the cluster administrator.

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  January 3, 2012 at 6:50 am

  #1427699

  I agree with Steve!

  ---

  
  
  My blog