i am trying to set up some stroed procs and triggers that select data from a
different server, but am unable to gain access to the server.
For example, on server A, I have added server B to the sysservers table,
In Query Analyzer, connected to server A, I try a command like this:
SELECT COUNT(*) FROM <ServerB>.pubs.dbo.Authors
When I run this, I get the following error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user '\'.
Interestingly, when I try and do this the other way round, so I am connected
to ServerB (my development machine), accessing data from ServerA, the
command works okay.
I guess this is something to do with security, logins, and roles, but I
don't really know where to start to fix it.
Any help would be much appreciated.