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.
>
>
Showing posts with label distributora2. Show all posts
Showing posts with label distributora2. Show all posts
Tuesday, March 20, 2012
Replication Problem
Labels:
configureed,
database,
distributor,
distributora2,
enabled,
microsoft,
mysql,
oracle,
publication,
publisher,
publisheri,
replication,
server,
settng,
sql,
subscriber
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.
>
>
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.
>
>
Labels:
configureed,
database,
distributor,
distributora2,
enabled,
microsoft,
mysql,
oracle,
publication,
publisher,
publisheri,
replication,
server,
settng,
sql,
subscriber
Subscribe to:
Posts (Atom)