I have run across these error message in many postings, but I can't find any solutions that fit my situation. The server is question is runningwin 2003 and SQL Server 2005. It was recently refreshed and was taken off the network for this. Now it is outside the firewall and not on the domain. This error message appeared about a week after it went back up.
2007-09-07 16:37:35.12 Logon Error: 17806, Severity: 20, State: 2.
2007-09-07 16:37:35.12 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: xxx]
2007-09-07 16:37:35.12 Logon Error: 18452, Severity: 14, State: 1.
2007-09-07 16:37:35.12 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: xxx]
The client it is looking for is the server the went up while this server was being upgraded. I don't know who the user is. How can I resolve this?