October 31, 2008 at 2:26 pm
HI
I am trying to add linked server from sql server 2000 to sql server 2005. My destination machine is having sql server 2005 ( named instance ) . Somehow after creating the linked server whenever i am clicking on tables it is throwing error :
Error: 17 SQL Server doesnot exist or access denied.
The login from which iam trying to add linked server exists on both the servers with sysadmin priviliges.
Can anyone please tell me how do i go about this ?????
October 31, 2008 at 2:44 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic595287-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply