Post reply

Start/Stop/Restart options are desabled on SQL 2012 in SSMS

  • August 14, 2013 at 7:04 am

    #278603

    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

    #1641369

    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

    #1641378

    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

    #1641685

    Start/stop/restart requires membership in the sysadmin or serveradmin fixed server roles.

  • August 15, 2013 at 2:45 am

    #1641693

    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