[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 SSPI handshake failed
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

SSPI handshake failed.


Applies to: Microsoft SQL Server 2005.


Error Message.

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17806
Date: 10/5/2007
Time: 3:00:01 AM
User: N/A
Computer: SQLCLUSTER
Description:
SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. [CLIENT: <ip address>].

 

 


Problem Description.

In our case the server that is showing the error has the MSSQLSERVER service running using a domain account that had a password change yesterday. All client/server applications were up and running, but all jobs started to fail, and we were unable to connect to the databases on that server using SQL Server Management Studio, returning an SSPI context error.



Solution.

Restarting the MSSQLSERVER service with the new credentials was the solution.

 


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.