linked server

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 ?


.

Relevant Pages

  • Linked server and delegation
    ... - run under a domain user account, ... User Admin1 can connect successfully to both SQL Servers. ... Now I setup a linked server from SQL1 to SQL2. ... Seems Kerberos delegation does not work and fall back to NTLM which does not ...
    (microsoft.public.sqlserver.security)
  • RE: Linked Server Lockes, mass testing
    ... "Ali Salem" wrote: ... > I am connecting two sql servers together as linked servers, the servers are running on windows 2003. ... > I call a stored procedure defined on the linked server as part of a transaction and it works properly. ...
    (microsoft.public.sqlserver.programming)
  • Re: Very slow access using MDAC2.8
    ... same indexes for the tables on all SQL Servers? ... connection to the linked server. ... > query runs fine, and return a result in less than a second. ...
    (microsoft.public.data.ado)
  • distributed transaction
    ... I have 3 SQL Servers which are linked server. ... Some transactions must be spread on more than SQL server and then I do not ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL linked server with ODBC
    ... and then run the query. ... I am having trouble extracting data from a Navision ... I am using sql server 2000. ... I created a linked server using OLE DB provider ...
    (microsoft.public.sqlserver.odbc)