Hi, Kerberos seems to be malfunctioning with SQL2008R2.
I have a new dev SQL2008R2 server called BDSDEV2 and an upgraded(in-place) SQL2008R2 server BDSTEST2.
From BDSDEV2 , I can successfully issue a linked server query to BDSTEST2
select * from bdstest2.eis_prod.dbo.wcs_agent
But from my client in SSMS, connected to BDSDEV2 , the double hop is failing to BDSTEST2 for same query
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have another BDSDEV1 server, which is SQL2008 and there double hop IS WORKING
From my client in SSMS, connected to BDSDEV1 ,I can successfully issue the query to BDSTEST2 .
The service accounts for MSSQLSERVER are both local admins on their servers and sa's
I have confirmed SPN is OK
This is from BDSDEV2 - sql2008r2 server.
C:\Program Files (x86)\Resource Kit>setspn -L tsqlssvc
Registered ServicePrincipalNames for CN=TSQLSSVC,OU=SvcAcct,DC=corp,DC=saif,DC=c
View Complete Post