Groups | Blog | Home
all groups > sql server replication > january 2007 >

sql server replication : Incorrectly entered password for Replication Distributor (2000)


thejamie
1/26/2007 11:38:54 AM
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,
thejamie
1/26/2007 11:53:01 AM
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


[quoted text, click to view]
Raymond Mak [MSFT]
1/26/2007 12:08:30 PM
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

[quoted text, click to view]

thejamie
1/26/2007 4:46:00 PM
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


[quoted text, click to view]
thejamie
1/29/2007 7:28:01 AM
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


[quoted text, click to view]
AddThis Social Bookmark Button