Post reply

SQL Serevr Services

  • September 30, 2012 at 8:49 pm

    #268326

    Hi All,

    Can we start and stop the SQL Server services without being the member of Adminstative group on local server ?

    and the windows login is having Sysadmin previlages on the SQL Server.

    Thanks and regards,

    Raghavender Chavva

    Thank You.

    Regards,
    Raghavender Chavva

  • October 1, 2012 at 4:18 am

    #1543894

    No, you can't. SQL server permissions are entirely independent of Windows server permissions, and you need to be a local admin to restart a service--there are no exceptions to this.

  • October 3, 2012 at 5:49 am

    #1544829

    Thank you for the reply.

    If it is SQL Server agent services instead of SQL Server services ?

    Thank You.

    Regards,
    Raghavender Chavva

  • October 3, 2012 at 5:57 am

    #1544835

    Again same rule applies, it is a service running on the windows box, so you need the correct rights to stop/start/restart services at the OS level.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy