SQL Server Fails to Start After Reboot Due to Permission Issues

Question

 

Hi, I had the local IT support install the SQL Server database on my laptop for development purposes. The installation was successful, and the SQL Server started properly.

However, after I restarted my laptop, the SQL Server service failed to start. I suspect this issue is related to permissions. The service is set to run under the NT SERVICE\MSSQLSERVER account, which might be restricted due to my non-admin user status.

Since an administrator installed the SQL Server, my account likely lacks the necessary permissions to start the service after a reboot. I do not have administrative rights, so I cannot even access the error logs in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL.

Answer 1

NT Service\MSSQLSERVER is the default account when installing SQL Server. It's a managed service account (MSA), and should be fine. I should also have the necessary permissions.

It seems to be configured to start automatically, so it should be running, but you cannot start and stop it yourself.

Anyway, you need to talk with your IT folks, since you don't even have access to the locks. Maybe they did something wrong.. They could post to this thread, if they need assistance.

Answer 2

Hi @Pongthorn Sangkaphet (TH)

Can you start the service manually?

The request failed or the service did not respond in a timely fashion.

You may consider set the start mode from Automatic to Automatic (Delayed start).

Services-> SQL server instance properties->General

Also, double check if it is the anti-virus's issue.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

The solution : Use Local system instead of NT Service\MSSQLSERVER