Restarting SQL Server using the GUI

Who is online?  0 guests and 1 members
Home  »  Blogs  »  briankmcdonald  »  Restarting SQL Server using the GUI
 
0
/5
Avg: 0/5: (0 votes)

Comments (2)

KeithHyer
KeithHyer said:

Hey, Brian - indeed good information.  I have a question about this one since you mentioned it - are there special permissions needed to do this? 

I am set up as a local admin on my machine and all of the SQL Servers in our company, however I have always received an error message when I try to do this:

 

===================================

Unable to stop service MSSQLSERVER on server {mymachine}.

===================================

Access Denied (ObjectExplorer)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Stop(Boolean stopDependentServices, Stack`1 stoppedDependentServices)

 

8/31/2010
 · 
 
by
briankmcdonald

Yes. You will need to be in the sysadmin role. I think you can also be a serveradmin as this role has the ability to restart SQL Server as well. I can't test right now, but I'll try to test when I have a little time.

Thanks,

Brian

8/31/2010
 · 
 
by
Blogs RSS Feed

briankmcdonald's latest blog posts

Blogs RSS Feed

Latest community blog posts