|
Home > Archive > MS SQL Server Connectivity > April 2005 > linked server
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]
|
|
| garfield cat 2005-04-26, 3:23 am |
| Hi,
I met a problem in linked server is that I have 2 sql servers A & B, I
create linked servers from A to B and from B to A. When accessing in A, I
can retrieve records from B through linked server, but when reverse, cannot
access.
The error returned is just like that the query is looking for the object in
the current server, not from the linked server.
Any idea ?
| |
| Andreas Mavrogenis 2005-04-27, 8:23 pm |
| Hi,
Did you check your name resolution within A and B servers. It sounds to me
like login issue,
Andreas
"garfield cat" wrote:
> Hi,
>
> I met a problem in linked server is that I have 2 sql servers A & B, I
> create linked servers from A to B and from B to A. When accessing in A, I
> can retrieve records from B through linked server, but when reverse, cannot
> access.
>
> The error returned is just like that the query is looking for the object in
> the current server, not from the linked server.
>
> Any idea ?
>
>
>
|
|
|
|
|