Announcement

Collapse
No announcement yet.

How to let a user control a service

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to let a user control a service

    Hi

    One of my servers runs a Sql server.
    One of my users is responsible for managing this Sql server.
    I want to give him permission to start and stop the " sql agent" service.
    I don't want add him to the local administrators group, or the power users group.

    I tried to grant him full control on the service in the registry, but with no luck.

    What to do?

    Thanks
    Yaniv

  • #2
    Re: How to let a user control a service

    How is he going to start / stop the service?

    I take it your going to grant him access to log onto the server?

    Michael
    Michael Armstrong
    www.m80arm.co.uk
    MCITP: EA, MCTS, MCSE 2003, MCSA 2003: Messaging, CCA, VCP 3.5, 4, 5, VCAP5-DCD, VCAP5-DCA, ITIL, MCP, PGP Certified Technician

    ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

    Comment


    • #3
      Re: How to let a user control a service

      He can access the server via rdp.
      After that, I'm open to suggestions

      I will be happy if he can use the " sql server service manager "

      Comment


      • #4
        Re: How to let a user control a service

        Check out the following:

        http://technet2.microsoft.com/Window....mspx?mfr=true

        Michael
        Michael Armstrong
        www.m80arm.co.uk
        MCITP: EA, MCTS, MCSE 2003, MCSA 2003: Messaging, CCA, VCP 3.5, 4, 5, VCAP5-DCD, VCAP5-DCA, ITIL, MCP, PGP Certified Technician

        ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

        Comment


        • #5
          Re: How to let a user control a service

          Tried to avoid them, but I think I must use security templates.

          How do I apply the security templates only to the specific server?
          The server is a member server.

          And which template should I choose?

          Thanks again

          Comment


          • #6
            Re: How to let a user control a service

            Someone?
            Aby help?

            Comment

            Working...
            X