What do you mean log in to server2 from server1 - presumably not via the linked server as the message is saying that the linked server does not exist. Have you created the linked server entry for NTSSQL2 on server1? What happens when you click on the linked server entry in enterprise mmanager.
========================================== Cursors are useful if you don't know sql. Beer is not cold and it isn't fizzy.
This is still an issue, albeit not the most important one. I was never able to get server1 to select, update, etc to server2. I could link them and log on but I couldn't get it to do any work. I still get the error message. I had to work around this issue and do all of the work from server2 to server1 because that was the link that worked.
Linked Servers
Forum Locked
Posted - 12/29/2001 : 12:06:53
