lundi 26 janvier 2015

Server 2012 Linked Server From An Instance


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