SSPI Handshake Failed error on SQL Server 2008
Posted on 2010-11-15
Running SQL Server 2008 on a Server 2008 R2 box. This server is a member of a domain, and it is not a domain server.
Ever since renaming the server (see below), we get an SSPI handshake error every minute in the SQL server log.
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: a universal address appears here]
The universal address is actually the IPv6 address that appears under the heading
Tunnel adapter 6TO4 Adapter when you do an ipconfig/all on the sql server itself.
We don't use IPv6 that I know of-- I've never configured it. If I disable IPv6 in the configuration window for the network card, the errors still appear.
The database and all user logins work fine. SQL Server Config Mgr shows all services to be up and running. This error started when we renamed the file server that this SQL server resides on.
To replace an older server, we created this server with a temporary name as a member of the domain. We brought the database over from the old SQL server. Tested it, worked fine. Renamed the old server while it was still in the domain. Then renamed this new SQL server to the old server's name. Made the appropriate changes in the DNS in the domain server.
Restarted the server and the errors began.
Looks like some local service is trying to login to the SQL server from the sql server itself and is now failing.