Can''t Manage Services in SSMS

Question

Can''t Manage Services in SSMS

EddieBaquet

SSC Veteran

Points: 267
More actions
April 5, 2006 at 8:35 am

#111616

Hello All.
This may sound like a stupid question, but I can't manage the Agent or the SQL service from SSMS. When I connect to my servers, the icon that displays whether the service is running is just a white circle. And when I right-click the commands to 'Start', 'Stop' and 'Pause' are all grayed out.
Can someone explain this to me?
Thanks!
Eddie

"If you don't take the time to do it right, when are you going to find the time to do it over?"

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Scorpion_66 SSCertifiable Points: 7891 More actions · Answer 1

Sounds like a permissions issue.......Do you have the correct permissions to manage the server your attaching to? And has the server been set up to allow remote connections?

EddieBaquet SSC Veteran Points: 267 More actions · Answer 2

Thanks for the reply.

Yes, I am a member of the sysadmin role. This is a development server that I have been working remotely on for a few weeks.

E

"If you don't take the time to do it right, when are you going to find the time to do it over?"

EddieBaquet SSC Veteran Points: 267 More actions · Answer 3

I just added my account to the Local Admin group on the box and it seems to be OK.

I was an admin there a couple of weeks ago - maybe I should clean out my desk

Thanks again.

E

"If you don't take the time to do it right, when are you going to find the time to do it over?"

EddieBaquet SSC Veteran Points: 267 More actions · Answer 4

So, now can someone explain to me why as a sysadmin in the SQL server I don't have the authority to affect the SQL services unless I am also a Local Admin on the box?

This is new

E

"If you don't take the time to do it right, when are you going to find the time to do it over?"

Scorpion_66 SSCertifiable Points: 7891 More actions · Answer 5

Scorpion_66

SSCertifiable

Points: 7891

April 5, 2006 at 9:12 am

#631029

lol....

Scorpion_66 SSCertifiable Points: 7891 More actions · Answer 6

It would be because you simply didn't have the authority to start and stop services from the system perspective, so regardless of what rights you had in SQL Server, the system would prevent it.