| ChrisR 2005-08-31, 11:23 am |
| Guys Im sorry to repost this as I just posted yesterday. But tomorrow is my
last day at this job and Id really like to get this solved for them before I
leave.
sql2k sp3
Ive always used Linked Servers and as such dont really know about Remote
Servers. Both boxes are set to use both WINNT and SQL Authentication.
Anyways, here is the deal.
Box1 -- Replication Publisher. Has a Remote Server defined for Box2, which
is a Subscriber to Box1.
So, Im trying to exec a proc on Box2 while logged on to Box1 while logged in
as SA. But I get the message:
Server: Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'BLA'because 'sa' is not defined as a remote
login at the server.
The SA password is the same on both these boxes, so while logged in as SA I:
sp_addlinkedsrvlogin
@rmtsrvname = 'cpdbovs01'
, @useself = 'true'
but that doesnt make my problem go away. The really funny thing here is that
I googled it, saw that I posted the same question years ago, see that I got
it, but cant read the answer.
TIA, ChrisR
|