x

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.

more ▼

asked Nov 10 '09 at 01:44 PM in Default

user-534 (yahoo) gravatar image

user-534 (yahoo)
1 1 1 1

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

1 answer: sort newest

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

more ▼

answered Nov 11 '09 at 07:34 AM

Mark Allison gravatar image

Mark Allison
479 1 1 4

It looks like this problem had started a few days ago on a machine that was working/rebooting perfectly. Looking at the doc now.
Nov 11 '09 at 10:54 AM user-534 (yahoo)
(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1933
x51

asked: Nov 10 '09 at 01:44 PM

Seen: 1010 times

Last Updated: Nov 20 '09 at 09:07 AM