Incorrectly entered password for Replication Distributor (2000)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thejamie - 26 Jan 2007 19:38 GMT

On the second screen in the wizard for configuring the distributor on SQL
2000, the correct server name has been used but the password is incorrect.
There is no way to remove the server name thus no way to reenter the correct
password to the distribution database. Help.

Signature

Regards,
Jamie

Reply to this Message

thejamie - 26 Jan 2007 19:53 GMT

Found my own answer - drop the database from the Enterprise Manager and and
then go in. The server will have been removed from the list and can be
readded with the correct password.

Signature

Regards,
Jamie

> On the second screen in the wizard for configuring the distributor on SQL
> 2000, the correct server name has been used but the password is incorrect.
> There is no way to remove the server name thus no way to reenter the correct
> password to the distribution database. Help.

Reply to this Message

Raymond Mak [MSFT] - 26 Jan 2007 20:08 GMT

Hi Jamie,

I am not sure if I understand your situation correctly but I am guessing
that opening SQL Enterprise Manager to connect to your
distributor->Right-click on Replication folder->Select "Configure Publisher,
Subscribers and Distribution..." from the context menu->The Password and
Confirm Password text boxes on the Distributor tab should allow you to
change the password you want. Or perhaps you have a different password in
mind?

-Raymond

> On the second screen in the wizard for configuring the distributor on SQL
> 2000, the correct server name has been used but the password is incorrect.
> There is no way to remove the server name thus no way to reenter the
> correct
> password to the distribution database. Help.

Reply to this Message

thejamie - 27 Jan 2007 00:46 GMT

In the instructions on the wizard it indicates a right click but I think not
in the wizard as I wasn't able to right click there but once I removed the
registration from the Enterprise Manager, the server was no longer listed and
I was able to re-add the server to the list using the correct password.

Signature

Regards,
Jamie

> Hi Jamie,
>
[quoted text clipped - 13 lines]
> > correct
> > password to the distribution database. Help.

Reply to this Message

thejamie - 29 Jan 2007 15:28 GMT

Raymond,

This whole question is a bit convoluted. I was trying to make publication
and subscription work from the SQL 2000 side when what needs to happen is for
the whole thing to take place on the SQL Server 2005 side. Hope I haven't
confused anyone.

Signature

Regards,
Jamie

> In the instructions on the wizard it indicates a right click but I think not
> in the wizard as I wasn't able to right click there but once I removed the
[quoted text clipped - 18 lines]
> > > correct
> > > password to the distribution database. Help.

Reply to this Message