Linked server issue

[tbode2006]

Architecture:
Computer 1 (C1) Computer 2 (C2)
Windows Server 2003 R2 Windows Server 2003
Standard Edition Small Business Server
SQL Server 2000 SQL Server 2000
No Firewall implemented No Firewall implemented

Problem: Trying to link to a database on C2 from C1. Right-clicking on the Linked Server branch of the tree and filling in the blanks, I end up with Error 17. When I try to link to a C1 database from C2, everything works fine. I have the computer name and IP in my Hosts file. I have tried using IP instead of the name.
Since I can link from C2 to C1, I decided to PUSH my data to a new table on C1 via INSERTS and keep getting a error message referencing ANSI_NULLS and ANSI_WARNINGS needing to be set. Have tried that, without success.

I need some insight as how to proceed to troubleshoot this so that I can link to C2.

 

[SQLBill]

When setting up the linked server, what type of security did you use (Security tab)? Does that security login have access to the other server? For example, some people choose "Be made using this security context:" and enter the SA login and password. That's great, unless there is a different SA password on each server. If you are using some other login, you need to make sure that the login being used has access to the other server.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[tbode2006]

I am using SQL Server authentication on both boxes. On C2, I created a new login to avoid using SA since no one remembers the existing password were I to change it.

"you need to make sure that the login being used has access to the other server." What do you mean by this? What am I looking for to check this?

 

[tbode2006]

Found my problem. Other server was a named instance, not the computer name.