I have 3 SQL Server 2012 Instances, 2 on SiteA on the same server SiteAServer. I have 1 on SiteB on server SiteBServer.
SiteADefaultInstance, SiteASecondInstance
SiteBDefaultInstance
- SiteBDefaultInstance can create a linked server to SiteADefaultInstance and SiteASecondInstance.
- SiteADefaultInstance can create a linked server to SiteBDefaultInstance.
- SiteASecondInstance CANNOT create a linked server to SiteBDefaultInstance.
I get the error
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON"
I am setting the security to be made using the current context.
I have ran setSPN for SiteAServer and SiteBServer. You don't have to change the commands if you have more than one instance do you? I am in the role sysadmin.
I have never experienced where it only worked one way before. Any suggestions where to look?
Aucun commentaire:
Enregistrer un commentaire