Hi All
I have a publication on server A, with transactional replication and a push subscription to remote server B. Updates from A to B work fine.
I want to run a stored proc on server B which obtains data from the subscriber db, then marks each record as processed. I am using integrated security throughout. When I try to update a record I get the following error:
Server: Msg 18456, Level 14, State 1, Line 5
Login failed for user 'sa'.
The line no has no reference to relevant code.
I have even tried to update the remote server A directly using
UPDATE Aserver.dbname.dbo.table SET ....
but still without success.
Can anyone out there shed some light on this problem? TIA