Error while trying to configure replication

• odednahir

  Old Hand

  Points: 318

  More actions

  September 22, 2003 at 8:15 am

  #82959

  When I try to configure the replication on a server for the first time, I get the following error message: "Could not connect to server '%' because 'distributor_admin' is not defined as a remote login at the server."

  I'm using the default values of the wizard.

  I have already done this a lot of times in the past and every time I had this error I had to uninstall and re-install the SQL server (nothing else helped). But now I'm looking for a way to do it without uninstalling the SQL Server.

  Any ideas?

  Thanks

• Larry C

  SSCommitted

  Points: 1543

  More actions

  September 22, 2003 at 8:59 am

  #475272

  Is the distributor on the same server as the publisher? If not, then you will have to give 'distributor_admin' logon rights on the remote distributor. You can use either a trusted or non-trusted connection. See BOL for more info.

• kakembo

  SSC Journeyman

  Points: 98

  More actions

  September 23, 2003 at 4:16 am

  #475368

  See sp_adddistributor

• jason_fife

  SSC Enthusiast

  Points: 174

  More actions

  September 23, 2003 at 8:19 am

  #475422

  You'll also need to create a linked server for any remote server involved with replication.

  MCDBA, MCSE

  Jason