Hi All, I am calling a stored proc through a job that calls a second stored proc on a different server. Replication is setup between the two servers, both systems are set in Mixed auth mode and both server services start using the same domain account. The problem is the job fails calling the second stored proc with this message:
Login failed for user 'Administrator'. [SQLSTATE 28000] (Error 18456). The step failed.
I get the same message regardless of the user set to run the job or how I configure the Remote Server options. (Not using Linked Servers due to Replication setup prior to my up and commance. If that matters.)
However, since the Remote Server connection was established with replication, I get an "Already Exists" when trying to add it as a Link Server and a "Can not be deleted" when trying to delete it as a Remote Server.
It appears to be permissions related but changing the Remote Login Name\Local Login Name does not appear to change a thing except to break the replication.