I'm trying to use Transactional replication between 2 servers called A and B. A is the distributor and the publisher, and B is the subscriber. subscription (on B) is configured to use impersonate process to connect to the distribution server (on A) and I think that's the issue. I see MSSQL login error as DOMAIN\B$ on A from B
If I don't use this account it seems that I must use an SQL account and not a windows account. Do you think it's the solution, or do I take the wrong way ?
I tried to use impersonation only cause I saw that lot of errors were fixed with it. I have same windows logins mapped to same roles on both servers. However if I don't use impersonation to connect to distributor I can't use a window login instead and need an SQL account , right ? I saw that Impersonation works if mssql instances of A and B are on the same host