Linking servers

Linking servers

Post by Steve Bajad » Wed, 24 May 2000 04:00:00

I'm trying to use the Linked server feature in MSSQL7 to define servers
and link them for querying purposes but I am unable to do so. Receive
message: SQL server not found.  I have set up an ODBC DSN and still
doesn't work.  Tried using login with impersonation. No go. Any ideas??

Steve Bajada


1. Is It Possible: Linked Server to Linked Server?


I am a little new to SQL Server, so bear with me.  I have an MSAccess 97
database on SERVER1 that has a couple tables in it that I need to access as
if they were local tables in an SQL server database on SERVER2.

On SERVER1, I have set up a "inked server" through enterprise manager with
the help of BOL to a the Access database which is on a local harddrive of

On SERVER2, I am able to set up a "linked server" to SERVER1 using the sa
account (or any other account for that matter), and I am able to see the
tables successfully in whatever the default database is for whatever login I
connect to the remote server with.

I tried adding a new login on SERVER1 that would default to the "linked
server" that I set up to the local access database on SERVER1.  However,
there does not seem to be any way to do this, as the option is not available
in the enterprise manager list of databases for this.

Is what I am trying to do even possible the way I am trying to do it?  Is it
possible to have "tiered" linked servers in this manner?  Am I making things
out harder than they have to be?  Please help!

Thank-you in advance for your responses.

- Mark

2. Sudden appearance of ORA-01017 thru link

3. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

4. p2k.exe Programmer2000 Trial

5. Error: 1203 while running a SP as a job

6. LINKED SERVERS : How to link MySQL server on SQL Sever 2000

7. SQL Server dialect functions

8. Reliable link to Oracle server (linked, server, oracle)

9. linked server, DTC, SQLOLEDB, Access, linked tables = HEADACHE!

10. Problem linking to Sybase as linked server

11. urgent: link mysql db as a linked server

12. How linked are linked servers ?