HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.replication » Error: 21670 SQL Server could not connect to the Distributor using the specified password. (Configure Distribution Wizard)

Topic: Error: 21670 SQL Server could not connect to the Distributor using the specified password. (Configure Distribution Wizard)

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/2/2008 10:05:03 AM

By: info

===================================

Connection to server [PRDSQLREPL01\BAMBAM] failed. (.Net SqlClient
Data Provider)

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

------------------------------
Server Name: PRDSQLCLSTVA01\AKIRA
Error Number: 21670
Severity: 16
State: 1
Procedure: sp_MSrepl_testadminconnection
Line Number: 82
===================================

I'm trying to setup a remote distributor (dedicated macine) on an
instance that I want to publish (dedicated machine). When I go
through the Configuration Distribution Wizard on the publisher to
setup distribution I get the error above.

I've set the a password that complies to my security standards, I've
reset it and reset it again trying to fix it.

Any one had this probem and come up with a resolution?

Thanks

Erik

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 6/10/2008 4:39:12 AM

By: Jim

Re: Error: 21670 SQL Server could not connect to the Distributor using the specified password. (Configure Distribution Wizard)

On Apr 23, 3:42=A0pm, i...@onlyhd.tv wrote:
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> Connection to server [PRDSQLREPL01\BAMBAM] failed. (.Net SqlClient
> Data Provider)
>
> ------------------------------
> For help, click:http://go.microsoft.com/fwlink?ProdName=3DMicrosoft+SQL+Se=
rver&ProdVer=3D...
>
> ------------------------------
> Server Name: PRDSQLCLSTVA01\AKIRA
> Error Number: 21670
> Severity: 16
> State: 1
> Procedure: sp_MSrepl_testadminconnection
> Line Number: 82
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> I'm trying to setup a remote distributor (dedicated macine) on an
> instance that I want to publish (dedicated machine). =A0When I go
> through the Configuration Distribution Wizard on the publisher to
> setup distribution I get the error above.
>
> I've set the a password that complies to my security standards, I've
> reset it and reset it again trying to fix it.
>
> Any one had this probem and come up with a resolution?
>
> Thanks
>
> Erik

I had the same problem and here's how I resolved it.

1- Connect to the server where your distribution db resides
2- Right click on the replication folder and select distributor
properties.
3- Select publishers. If you have already entered your publisher
uncheck and select OK
4- Add a new publisher
5- Enter a password for the administrative link
6- Connect to your publishing server and and create a new publication
using the remote distributor.
7- Enter the password you used earlier when assigning the publisher in
the distrubution properties

If you don't put in the password when you first add the publisher it
won't accept this password later so removing and readding with the new
password seems to work.

good luck,
Jim

Page 1 of 1 Pages