I have 2 servers
Server 1 has sql 2000 (SP2)
Server 2 has SQl 2000 + SQL 2005 (sp2)
Im trying to create a linked server on Server 1 to Server 2 SQL 2005
I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and try to create alinked server to SQl 2005 i get message "Server doent exit or access denied"
I have tried registering as server_ipSQL2005 but no luck
PS I can link to SQL 2000 on Server 2 from server 1 (i use the IP address of server 2) no problem just cant get it to link to SQL 2005,
What am i missing or doing wrong?
Thanks in advance
March 5, 2009 2:34 PM
March 6, 2009 7:25 PM