by Hi
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
database.
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?
Thanks