August 14, 2013 at 7:04 am
Hi,
I just realize that Start/Stop/Restart options are desabled on SQL 2012 in SSMS. Is there a way to enabled them?
Thanks,
Rem
August 14, 2013 at 7:08 am
This usually happens when you're not using a Windows login with permissions to start/stop/restart the services. Note that these aren't SQL Server permissions, they're permissions on the Windows server.
August 14, 2013 at 7:23 am
Thanks for your quick reply.
But I am able to start/stop/restart the service via the service administrative tools.
August 15, 2013 at 2:38 am
Start/stop/restart requires membership in the sysadmin or serveradmin fixed server roles.
August 15, 2013 at 2:45 am
Try starting SSMS by right-clicking and select Run as Administrator.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply