Search
Remote Support
1: Call first.
2: Press the icon below:
3: Wait for the file to download.
4: Run the file and allow admin permissions if prompted.
5: Wait for the code to appear.
6: Provide the code to your technician.
Friday
Jul262019

MSSQLSERVER Log On As a Service

So I have just a simple thing here:

When giving MSSQLSERVER the "Log on as a service" right (required for the SQL instance to run), it is taken away after every restart. How to resolve this in an easy way?

First, create a GPO and add "Local SQL Services" to the "Log on as a service" PolicyNext, apply that policy to an OU that contains the SQL server.

Note: in my case the SQL server is under "Member Servers" so I applied the GPO to that. This isn't an issue for the other non-SQL servers because the local group "Local SQL Services" doesn't exist on them anyway.

On the SQL Server, create a group called "Local SQL Services".

Put the user "NT SERVICE\MSSQLSERVER" into that group.

Run "GPUPDATE /FORCE" at an admin command prompt.

Restart the SQL server and you should find that the SQL services have started.

 

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.
Main | Sophos EndPoint Protection - Bug »