I've been having some freezing issues on SQL server 2005 SP3 and currently the error I'm trying to troubleshoot is "Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT:<local machine>] error 18456, Severity 14, State 16.
I'm running w2k8 server x64 on a Proliant DL360G5.
I have tried switching the user sql uses and switching back again to network service to get rid of this error which appears to be SQL using an account with incorrect credentials (mismatch between NT Authority\System and what SQL is expecting.
The server has approx 8 db's mirrored onto it and is SAN attatched and was experiencing freezing.
I checked the hardware - no issue.
I re-applied the SQL 2005 SP3.
I enabled tracing which showed errors related to performance - deadlocks have been noted so I enabled DBCC TRACEON (1204, 1222) and some stack dumps can be seen.
I have upgraded to w2k8 sp1 (and re-applied sql 2005 sp3).
However the only error in the log files is the one previously mentioned. "Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT:<local machine>].
I have been using SQLIO to test throughput to the SAN incase the latency or errors are related to this and have also been using iometer.
Next steps for my issue are to try and fix the error Login Failed...
If this doesn't help I'm going to r
View Complete Post