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?


more ▼

asked Nov 10, 2009 at 01:44 PM in Default

avatar image

user-534 (yahoo)
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Nov 11, 2009 at 07:34 AM

avatar image

Mark Allison
479 1 3 8

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 10, 2009 at 01:44 PM

Seen: 1302 times

Last Updated: Nov 20, 2009 at 09:07 AM

Copyright 2018 Redgate Software. Privacy Policy