bbrown 40722 (7/12/2011)
My issue is the same as the first post " I can't use right-click the instance icon to select "start", "stop", "pause", "resume" or "restart" because they are all grayed out. But all the rest operations are available" I don't think it is related to a specific version. I found something yesterday that I am going to try that says it is related to the SQL clinet.
If that your issue, it is likely to be permissions related. What you need to have is access to view the 'Server State'.
The first thing to try is to run ssms and connect to the instance as the login used for the sql service (assuming its a domain account). That should work fine.
Now check that the same account has been setup for lock pages in memory, do this: Run:gpedit.msc --> Computer Config --> Windows Settings --> Security Settings --> Local Policies --> User Rights and ensure that Lock Pages in Memory is set to the same account as you service account (this will have to be a domain account).
Once that is done get your user or dba group (if multiple users) setup in the local admin group of the server. Really all you should need is access to Services but it never hurts to have Admin (for backup file permissions and various others).
Let me know and good luck.
Adam Zacks-------------------------------------------Be Nice, Or Leave