Hi
I have three MS SQL 2000 Servers distributed as follows: (img
Server 1:
Name: JBCB_SRV1
OS: Windows 2003 SE
DB: MS SQL 2000 Server SE
MS SQL Replication: Publisher
Source DB: Northwind
Server 2:
Name: WEB
OS: Windows 2000 Server SE
DB: MS SQL 2000 Server SE
MS SQL Replication: Subscriber
Destination DB: TEST
Server 3:
Name: 192.168.3.15 (INTERNETSRV)
OS: Windows 2003 Advance Server
DB: MS SQL 2000 Server SE
MS SQL Replication: Subscriber
Destination DB: ABC
JBCB_SRV1 is running on Windows 2003 Server and MS SQL 2000 server, is the replication server configured as Publisher. WEB is running on Windows 2000 Server and MS SQL 2000 Server configured as subscriber. It has been running for last 3-4 years without a problem.
WEB server hardware is very old, so we want to replace the old server with a new one. So we stopped and disabled the replication between JBCB_SRV1 and WEB. Then we configured a new replication between JBCB_SRV1 and INTERNETSRV (192.168.3.15). Of course, we registered the INTERNETSRV server using “sa” user with INTERNETSRV sa’s password. As soon as the replication starts it gives the following error:
Full message: Login failed for user ‘SA’. Reason not associated with a trusted SQL server connection.
All SQL agents are running on all the servers.
When we switch back the replication between JBCBSRV1 and WEB it works fine.
Can you please help solving the problem?
Thanks
Regards
Faruque Alam