Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
juancabrera
Starting Member
30 Posts |
 Posted - 2009-05-06 : 14:37:34
|
| Hello,I am having a bit of a problem understanding a certain behavior on Linked Servers. I am able to create a linked server between ServerA and ServerB. On my PC I am connecting to both Servers and trying to access the linked server. Something like this:PC --> Server A(Port 35001) ---Linked Server To---> ServerB(Port 35002).There is a firewall between my PC and both servers, but not between the servers which happen to be on the same subnet. I have firewall access to those ports(35001, 35002).Following is what is under the general tab on the Linked server:Provider: SQL Native ClientProduct Name: My Linked ServerData Source: ServerB\InstanceName, 35002Provider String:Location:Catalog: MyDatabaseLike I said I go to the server itself, it works. However, if I try accessing the Linked server from my PC via management studio, with a connection to ServerA, I am getting the following error message:"Login failed for user 'NT Authority\Anonymous Logon'. (Microsoft SQL Server, Error: 18456)"Could this have to do with failure to have access to another port? Perhaps a port that is being firewalled? Or could it be bad SPNs on Active Directory?Thanks,Juan. |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2009-05-06 : 15:28:53
|
| Both your domain account and the machines running SQL Server need to be marked as "trusted for delegation" in AD. Have a look at http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx (although it's written for SQL Server 2000, the same applies to 2005). |
 |
|
|
|
|
|
Linked Servers