18456 :Login failed for user 'NT AUTHORITY\SYSTEM'.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andyd - 19 Mar 2008 17:43 GMT

Hello all,

Over the last week or so we have begun receiving this error in the event
viewer and until the system is rebooted and then the sql server service
restarted (HAS to be done after a reboot) our CRM system and any other sql
related services are unanavailable.

I have verified that NT AUTHORITY\SYSTEM is a valid user and has SA access
to ALL the databases we have.

I have searched everywhere and the standard response is to make sure its a
valid user. In my case its already there so im unsure of where to go next.

We are running sql server 2000 standard with all the latest patches on win2k
as up to date as that can be as well.

Thanks in advance.

Andy

Reply to this Message

Chris Wood - 19 Mar 2008 18:35 GMT

Andy,

We started to see this on a W2K3 SP2 cluster after the upgrade to SP2
because the failover doesn't seem to happen fast enough.

Chris

> Hello all,
>
[quoted text clipped - 16 lines]
>
> Andy

Reply to this Message

andyd - 19 Mar 2008 18:53 GMT

Hi Chris,

Thanks for the tip but we are running win2k and sql 2k still here and its a
standalone, we dont cluster here.

Andy

> Andy,
>
[quoted text clipped - 23 lines]
>>
>> Andy

Reply to this Message