I have a network based on Win 2000 advanced server, and my database is SQL Server 6.5 using replication from a publisher to subscribers. Recently I have changed all "sa" passwords, which were the same on all servers, and after this only change the Replication of data is not working anymore.
I have this error:
28000[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed
How do I fix that?
I need some help about.
Regards,Is the error for the log reader, the distribution agent, or both?
-PatP|||Hi,
The log reader is working properly. The error is from distribution task
ie SERVER1..BD1 -- Replication --> SERVER2..BD2
taskname: SERVER1_BD1_SERVER2_BD2|||See sp_changesubscriber (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_4kaa.asp) for details.
-PatP|||See this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;216848 is any help.
No comments:
Post a Comment