Microsoft KB Archive/225129

= BUG: Error 18456 when trying to configure publishing using a remote distributor =

Article ID: 225129

Article Last Modified on 7/6/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q225129



BUG #: 52798 (SQLBUG_70)



SYMPTOMS
The following error message is returned when you attempt to configure publishing using a remote distributor if the password required for the publisher to establish an administrative link with the distributor is NULL:

SQL Server Enterprise Manager could not configure '' as the Distributor for ''.

Error 18456: Login failed for user 'distributor_admin'.



WORKAROUND
 Configure the publisher as a trusted publisher to the distributor so that a password is not required to establish the administrative link between the publisher and the distributor. To change the security settings for the publisher, follow these steps:  On the Tools menu, select Replication. On the Publisher tab, highlight your publisher in the list, and then click the ellipsis (...) next to that publisher. In the Replication Agents on the Distribution Log into the Publisher section, select the By impersonating the SQL Server Agent account on '{ServerName}' (trusted connection) check box.

-or-

</li> Do not use a login that has a NULL password for establishing the administrative link between the publisher and the distributor. The administrative link password can be set in Enterprise Manager. To do this, follow these steps:  On the Tools menu, select Replication.</li> On the Distributor tab, under the Administrative link password section, enter your password in the password and confirm password fields.

Note We recommend that you use a strong password in this step.</li></ol> </li></ul>

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

<div class="moreinformation_section">

Steps To Reproduce the Problem
<ul> The following steps should be performed at the distributor:

 In the SQL Server Enterprise Manager (SEM), go to the Tools menu and select Replication.</li> Next, select the Configure Publishing and Subscribers... option.</li> The Configure Publishing and Distribution wizard will be started if replication is not already enabled on this server.</li> Choose the local server as the Distributor.</li> Do not use the default configuration, but customize the publishing and distribution settings as follows:  In the Enable Publishers window, enable a publisher of your choice and then click the ellipse button next to that publisher.</li> In the "Replication agents on the Distributor log into the Publisher:" section of the Properties dialog box, select the "Using SQL Server Authentication of this account option:" and specify the login and password. Make sure that this login has no password.</li> In the "Administrative link to the Distributor" section of the Properties dialog box, select the "A password is required to establish a link to the Distributor" option.</li> Complete the wizard.</li></ol> </li></ol> </li> <li>The following steps should be performed at the publisher: <ol> <li>In the SQL Server Enterprise Manager (SEM), go to the Tools menu and select Replication.</li> <li>Next, select the Configure Publishing and Subscribers... option.</li> <li>The Configure Publishing and Distribution wizard will be started if replication is not already enabled on this server.</li> <li>Choose the remote distributor.</li> <li>When prompted for the Administrative password leave the password field blank.</li> <li>Use the default configuration and click Finish to complete the wizard.</li></ol> </li></ul>

The process fails with the following error message:

SQL Server Enterprise Manager could not configure '<Distributor_name>' as the Distributor for '<Publisher_name>'.

Error 18456: Login failed for user 'distributor_admin'.

Additional query words: Replication

Keywords: kbbug kbpending KB225129

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.