Hi, there,

I have two SQL Server 2000, which are SQLA -- with SAN connected; SQLB --  
just a bald SQL Server.

I want to set up linked server from SQLA , so I can run query like "select *
from SQLB.dbname.dbo.tablename". The command I use is

sp_addlinkedserver  @server = 'SQLB'

After I ran this code, I span the "Linked servers" node of Enterprise
Manager, I saw an image of a linked server named "SQLB". Then I run the
query  "select * from SQLB.dbname.dbo.tablename" from Query Analyzer of
SQLA, I got the following errors

Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.

I'm the system administrator of the two servers, and the account I ran the
query is sys admin account. I don't know why the command failed. I drop the
linked server and readd the linked server again. I got the same result.

Who can help a bit?

Thanks so much in advance,

Jamie