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

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

Randall Arnold

"Jamie" <gsadd@yahoo.com> wrote in message
news:O5ALGyfIGHA.1132@TK2MSFTNGP10.phx.gbl...
> 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
>