Tuesday, March 20, 2012

Replication Problem

I am settng up a Distributor, Publisher and Publication. The subscriber wil
l be enabled later.
A1 is the Distributor
A2 is the Publisher
I configureed A1 as Distributor and enter a password for A2 to use when conn
ecting.
Then, I enabled A2 to be a Publisher.
When I try to create the Publication on A2, I get the following error:
Error 20028: The Distributor has not been installed correctly. Could not e
nable database for publishing. The replication option 'publish' of database
'dbname' has been set to false.
As a test, I enabled my local SQL Server to be a Publisher using the Distrib
utor and it works fine.
Both A1 and A1 have SQL Services under the same domain admin. From A2, I ca
n see the snapshot folder on the Distributor.
Could someone provide some insight into this?
Thank you in advance.
Robert M.Thanks to those who read this...I kept at it. Did a select @.@.servername and
it was null on the Publisher. Ran sp_addserver 'a2', 'local' and restarte
d the services.
Now I can create the Publication.
Robert M.
"Robert M." wrote:

> I am settng up a Distributor, Publisher and Publication. The subscriber w
ill be enabled later.
> A1 is the Distributor
> A2 is the Publisher
> I configureed A1 as Distributor and enter a password for A2 to use when co
nnecting.
> Then, I enabled A2 to be a Publisher.
> When I try to create the Publication on A2, I get the following error:
> Error 20028: The Distributor has not been installed correctly. Could not
enable database for publishing. The replication option 'publish' of databa
se 'dbname' has been set to false.
> As a test, I enabled my local SQL Server to be a Publisher using the Distr
ibutor and it works fine.
> Both A1 and A1 have SQL Services under the same domain admin. From A2, I
can see the snapshot folder on the Distributor.
> Could someone provide some insight into this?
> Thank you in advance.
> Robert M.
>
>

No comments:

Post a Comment