“SSPI handshake failed” could result when the security event log has reached the maximum log size

I see a lot of issues related to SQL Server connectivity. One common error I see in the SQL Server logs is the SSPI error. Logon Error: 17806, Severity: 20, State: 2. Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT:192.168.0.5] Logon Error:…

1

SQL Server Query Performance when running query from a Windows 2008 Server

Recently I faced two cases in which we can see slow query performance when we run a SQL Server query from a Windows Server 2008 client machine. The query takes more time to complete when we run it from a Win2K8 machine as compared to a Win2K3 or WinXP machine. To test this we opened…

2