I am settng up a Distributor, Publisher and Publication. The subscriber will 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 connecting.
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 database 'dbname' has been set to false.
As a test, I enabled my local SQL Server to be a Publisher using the Distributor 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.
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 restarted the services.
Now I can create the Publication.
Robert M.
"Robert M." wrote:
> I am settng up a Distributor, Publisher and Publication. The subscriber will 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 connecting.
> 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 database 'dbname' has been set to false.
> As a test, I enabled my local SQL Server to be a Publisher using the Distributor 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.
>
>
Tuesday, March 20, 2012
Replication Problem
Labels:
configureed,
database,
distributor,
distributora2,
enabled,
microsoft,
mysql,
oracle,
publication,
publisher,
publisheri,
replication,
server,
settng,
sql,
subscriber
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment