Reporting Services IPv6 login error after Server name change
Posted on 2010-11-16
SQL server 2008 running on a Server 2008 R2 box, member of a domain, not a domain controller. We had to change the name of the server. Changed it, rebooted; SQL server and server 2008 worked fine except for a logon error that apeared in the SQL Server log every minute.
SSPI handshake failed with error code 0x8009030c....... connection closed. [CLIENT: the IPv6 IP address). We are not using IPv6 that I know of.
Using nltest to put net logon into debug mode revealed the issue was the SQLexec account (domain account) that is used for several SQL services, including SQL Agent and the main SQL service. But SQLexec works fine with these other services. Stopping Reporting Services stopped the errors.
Any idea why renaming the file server triggered the errors and how to fix this without reloading SQL server?