Connection issue

• Dan DePuy

  SSC Journeyman

  Points: 75

  More actions

  February 25, 2005 at 7:44 am

  #163786

  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/

• dscott

  SSC Rookie

  Points: 33

  More actions

  June 22, 2005 at 9:33 am

  #567539

  Did you ever find an answer to this? i'm having the same issue.

   

  thanks,

  Darren S. Scott

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 22, 2005 at 3:36 pm

  #567716

  can you check that

  select @@servername 

  is the same as

  select SERVERPROPERTY ( 'serverName')

  if it returns null you need to

  exec sp_dropserver 'old name'

  sp_addserver

    @server ='actualname' ,  @local =  'local'

  
  * Noel