I have setup transactional replication by following link. Everything I did as per document. But when I verify synchronization status, as per mentioned link, I receive an error

The process could not connect to Subscriber

After checking logs, I found that subscriber is connecting to wrong account.

Login failed for user 'Subscription_Machine\repl_distribution'. Reason: Could not find a login matching the name provided. [CLIENT: Publisher IP]

Now, please adivse how can I change this account <Subscription_Machine>\repl_distribution?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.