Linked server problems

155 pts.
Tags:
Linked Server
Linked SQL Servers
Microsoft SQL Server 2000
SQL Server 2005
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • KH
    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
    155 pointsBadges:
    report
  • Denny Cherry
    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?
    66,360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following