question

user-534 (yahoo) avatar image
user-534 (yahoo) asked

SQL server login problems on reboot

I found that when one of our machines reboot, I see audit errors in the event viewer saying that SQL Server Express cannot logon with NT Authority\System, there after my service application gives a similiar login error and does not start.

If I then start my service application manually (with services.msc), it starts perfectly. So the problem is only with rebooting.

So it looks like it is an issue with when the System account is available when SQL server service starts?

I have now switched to mix mode authentication and created an sql server account. I have changed my connection string to use it and on reboot I still get SQL Server express complaining about not being able to login with this account and also my service application gives the same error. Once again, manually starting my service application works.

Any clues?

JD.

sql-server-2005sql-server-express
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Mark Allison avatar image
Mark Allison answered

I suggest you check that the SQL Express service account has the correct permissions according to this article.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.