Linked server problems
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
Software/Hardware used:
Software/Hardware used:
ASKED:
March 5, 2009 2:34 PM
UPDATED:
March 6, 2009 7:25 PM
RELATED QUESTIONS
Answer Wiki:
Have you configured SQL 2005 to accept remote connections?
Are you sure that the instance name is correct?
Are you able to connect to the SQL 2005 instance from the other server?
Is the SQL Browser running?
This <a href="http://itknowledgeexchange.techtarget.com/sql-server/steps-to-troubleshoot-connections-to-your-sql-server/">blog post</a> shows how to troubleshoot connections to a named instance.
To see all answers submitted to the Answer Wiki: View Answer History.
Have you configured SQL 2005 to accept remote connections?
Yes
Are you sure that the instance name is correct?
Yes
Are you able to connect to the SQL 2005 instance from the other server?
The machine where SQl 2005 is installed also has SQL2000 on it if i go into SQL 2000 on that machine i can create a linked server to Sql2005 no problems , but when i try to do the same thing from a different machine with SQL2000 on it, it wont connect (it will let me link to the SQL 2000 but not SQL2005 .
Is the SQL Browser running?
Yes
But are you able to open Query Analyzer on the remote machine and connect to the SQL 2005 instance?
Have you looked at the blog post I refereed to above? What are the results of those tests?