Post reply

Can I start and stop sql server with non admin previledges on my pc ?

  • June 30, 2005 at 8:57 pm

    #87942

    I work as an administrator in my organisation. We have a development team of 6 people who have sql server installed on their machines.I am fairly new to SQL server.

    My comany has decided to take off the admin previledges from each user that includes developers also.When the admin access is taken off then can't stop or start a sql server thorugh Enterprise manager.

    When a developer tries to stop a sql server, it give following error

    an error 5-(access denied) occurred while performing this service operation on the MSSQLServer service

    Would appreciate if you could help me out ?

    Thanks

    Prashant

     

     

  • July 4, 2005 at 12:59 pm

    #570735

    There is a server role called Process Administrators.  If you are a member of this role you can start and stop the SQL Server Service as well as the Agent Service.

Viewing 2 posts - 1 through 2 (of 2 total)

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