xnleiden (11/27/2009)
Hello Animal MagicI did try services.msc and connect it to the server and all start, stop and restart options are there for MSSQLSERVER service.
And the windows account I used for log on to my local workstation is a domain admin FYI.
Could you please advise me a bit more? Thanks.
So you are able to start and stop services from the same account that launched SSMS, when you use services.msc?
What version of the Tools are you using?
Is this an issue for all SQL Instances?
Is the domain admin account the same account you are using to start sql services by chance?
Are the sql services using a domain account?
Do you have the same issue when connecting to the instance using your domain account via SSMS, and not SA?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events