SQL Serevr Services

  • 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

  • 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.

  • Thank you for the reply.

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

    Thank You.

    Regards,
    Raghavender Chavva

  • 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