Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I recently installed SP1 on my 2012 SQL Server. Ever since then SSMS has behaved a little weirdly when I connect from my pc rather than from the local server itself.

I no longer see the green "running" icons on the server and on the agent, and several menu options are greyed out (Start/Stop/Restart on server menu and agent menu).

enter image description here

Also, when I try to access the Activity Monitor, I get the following error:

enter image description here

Error Detail

I found the following article about the Activity Monitor. I followed the steps there (although I am a local admin on the sql server and should have had all of those permissions already) to no avail. The server is running Windows 2008 R2 Datacenter SP1. When I remote desktop to the server itself and use SSMS directly I have none of these issues, and when a domain admin connects to the server through SSMS remotely everything also works for him.

Any ideas?

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

The behavior you are seeing happens if you aren't recognized as having permissions to manage services on the remote server. This MSDN article describes some possible solutions on how to grant users rights to manage services.

Does the service account for the agent have local administrator permissions on the server? Have you stopped and started database services and the SQL Server agent service on the server since encountering this problem?

share|improve this answer
    
That article is for windows server 2003 - will it still apply for 2008? The service account is a managed service account which I've added to the local admin group. I restarted the agent service which didn't do anything but I can't restart database services at the moment since this is a production server. I am a local admin on the server as well. –  Mansfield Jul 4 '13 at 19:28
    
After rebooting the server having made the service accounts local admin, it started working. Thanks! –  Mansfield Jul 8 '13 at 12:13
add comment

If you have entered the correct log in info, the issue is most likely linked to the fact that the sqlserver service has been disabled somehow. You can check its status and re-enable it by going to services.msc.

share|improve this answer
    
How would I be able to connect and run queries if the service is disabled? –  Mansfield Aug 17 '13 at 21:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.