|
Home > Archive > MS SQL Server ODBC > January 2006 > add linked server problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
add linked server problem
|
|
|
| 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
| |
| Randall Arnold 2006-01-31, 9:23 am |
| 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
>
|
|
|
|
|