sql server odbc: add linked server problem -- sql server odbc

add linked server problem

Jamie
1/25/2006 4:13:07 PM

sql server odbc:

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

Re: add linked server problem

Randall Arnold
1/31/2006 8:33:47 AM

Make very sure that the folders involved (db location, etc) have full
read/write/execute access for the login account.

Randall Arnold

[quoted text, click to view]