<!-- [if gte mso 10]> <mce:style> Hi all,
I have a problem with the replication in place in my company.
the context:
- 2 servers in a private dmz accessible from the Internet, no domain, so no windows authentification, only SQL authentification.
- SQL Server 2005 SP3 - build 9.00.4053.00 - on win 2003 SP2 running on both server with transactional replication.
the problem:
1- for some reason, the replication didn't work anymore, here was the error: connection failed for user <MyUser>
the user was correct and we didn't change the password.
2- So I change the security context and the user in the linked server
repl_distributor properties in both server. Now, the problem is that the replication got the error:The process could not execute 'sp_repldone/sp_replcounters' on <Distributor/subscriber>.
so, I tried to remove the publication, but I got through this error:
Could not connect to server <distributor/subscriber> because <MyUser> is not defined as a remote login at the server. Verify that you have specified the correct login name. .
I can't remove the linked server either:
Cannot drop server 'repl_distributor' because it is used as a Distributor in replication. (Microsoft SQL Server, Error: 20581)
has anyone encountered this problem? any suggestion on how to resolve this issue would be much appreiate.
thanks for your help
Nandini
Nandini
