Linked Servers question

Linked Servers question

Post by Jack » Fri, 07 Jul 2000 04:00:00

I noticed, when linking servers, only pure SQL7 Servers
(sp_addlinkedserver 'ServerM',
N'SQL Server')

I'm linking SQL server M to server N both are NT security only, using the
SQL service account in the M server as a user with security permissions on a

When I logon to server N directly I can do selects on a view of a table in
the connected database.
But when I log on to server N from another machine via Enterprise manager, I
can not get my select statements to work. It comes up with user / can't log
in or something like that. I've tried all sorts of NT impersonations, none
of them made a difference.
The links views, probably work with stored procedures because they are run
in their own space.

I don't have this problem with ODBC Linked Servers.

Is this a feature of linking SQL7 servers?



1. Linked Server Question 7.0 / 6.5 (ASAP would be great)

I am trying to access 6.5 server tables from  7.0.  I did not execute the
sp_addlinkedserver for the 6.5 server because I have already set the 6.5 server
up for replication (from 7.0 to 6.5).  The 6.5 server is already in the
sysservers table.

when i run a query to try to get access to the 6.5 data from 7.0, I get the
message "server <6.5 server name> is not configured for data access"

Please help me overcome this problem.


2. variable as table name in sproc ?

3. linked server question

4. Monitoring database at work

5. Linked Server Question

6. Connecting to Oracle with Query Analyzer

7. linked server question

8. Getting MSG 8207, increased ulimit, still have problem

9. Linked server question

10. Linked Server Question

11. A linked Server Question?