I have 2 servers.
Server 1 has SQL 2000 (SP2).
Server 2 has SQl 2000 + SQL 2005 (sp2).
I'm 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 a linked server to SQl 2005, I get the message "Server doesn't 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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!