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