Post reply

How do I grant service startup to a domain user?

  • June 14, 2011 at 3:51 pm

    #239249

    Ntrights.exe Utility can't be the only way, or vbscripts? Any help would be much appreciated.

    Thanks,

    DK

  • June 15, 2011 at 11:28 am

    #1339167

    Well it wasn't a victorious moment, but I ended up giving the domain user admin privileges and it worked.

    Thanks,

    DK

  • June 15, 2011 at 1:20 pm

    #1339271

    Don't do this!

    It worked because by default Domain Admin members are members of the local Administrators group. The local Administrators group I believe has logon as service rights. The easiest way to do this, and do it right, is to log on to the server as an administrator level user. Then use SQL Server Configuration Manager to configure the service account for SQL Server. This tool will automatically grant the appropriate rights for SQL Server.

    If you're looking to do this for something else, the services applet should do the same. Failing that, you can modify the local security policy.

    K. Brian Kelley
    @kbriankelley

  • June 15, 2011 at 1:27 pm

    #1339279

    Set up accounts: http://msdn.microsoft.com/en-us/library/ms143504.aspx

    Verify permissions: http://msdn.microsoft.com/en-US/library/ms144238%28v=SQL.90%29.aspx

    I completely agree with Brian. don't grant domain admin. Use the Config manager to set the rights.

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

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