CODEWITHSUNDEEP
sql-serverservice
A.Pissicat
A.Pissicat

Reputation: 3265

Service SQL Server - Fail to start

I have a trouble with a service SQL EXPRESS. I found a workaround but the error comes back sometimes. It happens on a customer PC so I want to solve the problem definitely.

My problem is :

My workaround is :

I saw that it can by caused by a windows update or a user password change. How can I fix definitely this trouble ? It the third time in few months it happens, I solved it but it's not very reassuring for the customer.

Upvotes: 0

Views: 154

Answers (1)

sniperd
sniperd

Reputation: 5274

The issue sounds like the user accounts password required a change, he probably changed it but never thought to change the password the service uses. So the next time that server reboots (and the service restarted) it failed. This is a very common thing to happen. The two solutions I would recommend are as follows:

  • If you do not need the SQL to run under a specific account, don't have the service start as a specific user. That is completely normal.
  • If SQL must start and run as a specific user, create a user account and tell the customer this is a service account. Make sure the account has the desired privileges. It can be a domain or a local account and make sure the password is set to never expire.

Upvotes: 1

Related Questions