Not able to connect to Remote Distributor from Publisher using Administrative Link Password

Question

I am not able to connect to Remote Distributor from Publisher using Administrative Link Password. I have configured the Distributor on 1 m/c and Publisher on another m/c. When i use the wizard to configure the publisher using remote distributor. I have also specified the same Admin Password link (distributor_admin) in the distributor m/c.

 

I am getting the following message:

 

 

TITLE: New Publication Wizard
------------------------------

SQL Server could not connect to the Distributor using the specified password.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantConnectAdminPassword&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Connection to server [SANMENON] failed.
OLE DB provider "SQLNCLI" for linked server "D956CF83-AE2E-4FC5-83DD-BE90D84A3950" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "D956CF83-AE2E-4FC5-83DD-BE90D84A3950" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". (Microsoft SQL Server, Error: 21670)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21670&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Answer 1

Right click on the replication option in your database instance where you have configured your distributor, and go to distributor properties. Go to(click) the publisher option on the left side panel. You will see the place where you need to specify a password for your publisher. Change the password and try once more. I think ur problem will be solved.

Answer 2

Thanks. It worked.

Answer 3

Hi

Have done the same but does'nt work me still getting the same error. Pls help. 

---

Apps Dev

Answer 4

I'm getting the same problem as the poster.  Unfortunately, nothing has worked to resolve the issue.

- Changing the administrative link password (Various strong type passwords tried, nothing worked)
- Dropping/recreating the distributor
- Changing the 'Agent Connection to the Publisher' from Impersonation to SQL Server Auth (neither work)

Anyone else have ideas?  It used to work but the User Account that was setup to start the SQL Server Service expired.  Problems started after that.

Answer 5

i have the same thing

distributor is build 4262 and the publisher is 3161. trying to set up a server as a publisher and it's not working