Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  data replication connection error

Author  Topic  DanDePuy Starting Member 1 Post Posted - 2005-02-25 : 09:35:00 Hello, I have been having a problem with the Data Replication feature in SQL Server running in Windows 2000 Server. When configuring the server for data replication, I receive the following error message: "Error 18485: Could not connect to server "S-DATA2" Because 'distributor_admin' is not defined as a remote login at the server." To further elaborate on this issue, please allow me to provide you with the following details: This is something we do on a regular basis, so we are familiar with the process. The servername is registered correctly in enterprise manager using SQL authentication. It logs in without a problem. I tried using windows authentication and mixed mode authentication, but the same event occurred in both cases. I checked and verified that SQL is waiting on port 1433. Neither of the servers involved in the replication is behind a firewall; they are on the same VPN. I checked and verified that I had plenty of free memory and that the snapshot folder is correct and readily available. The distribution database and connect.log files are in the same directory, which is readily online and available. Just for test purposes, I set up the same server as both publisher and subscriber. I have reviewed the following kb articles and followed the troubleshooting steps to no avail: KB 321822 http://support.microsoft.com/default.aspx?scid=kb;en-us;321822 KB 287932 http://support.microsoft.com/kb/287932/EN-US/