Post reply

Error while trying to configure replication

  • 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

  • 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.

  • September 23, 2003 at 4:16 am

    #475368

    See sp_adddistributor

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply