Incorrectly entered password for Replication Distributor (2000)

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.
Regards,
Jamie
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.
Regards,
Jamie
"thejamie" wrote:

> 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.
> --
> Regards,
> Jamie
|||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
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:69D7219B-7DE8-454D-A93C-7CAB5F96A151@.microsoft.com...
> 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.
> --
> 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
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.
Regards,
Jamie
"Raymond Mak [MSFT]" wrote:

> 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
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:69D7219B-7DE8-454D-A93C-7CAB5F96A151@.microsoft.com...
>
>
|||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.
Regards,
Jamie
"thejamie" wrote:
[vbcol=seagreen]
> 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.
> --
> Regards,
> Jamie
>
> "Raymond Mak [MSFT]" wrote: