Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / June 2006

Tip: Looking for answers? Try searching our database.

Transactional Replication Errors 20028

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
laststubborn - 28 Jun 2006 10:09 GMT
Dear All,
I am trying to put distirbuter and subscriber on the same SQL Server
Machine. I achieved to enable the remote distributer on my server 2.I
was able to enable server1 as a publisher. I wanted to create my
publication on my server 1 and use the server 2 as a distributer and
the subscriber. However I have recieved a series of error messages
while I was creating the publication.
Here are the error messages :

SQL Server Enterprise Manager could not enable database 'aaaaa' for
snopshot or transactional publications.
Error 20028 : The distributer has not been installed correctly. Could
not enable database for publishing.
The replication option 'publish' of database 'aaaaa' has been set to
false.
Can somebody help on this issue please?

Regards
Hilary Cotter - 28 Jun 2006 12:23 GMT
Did you configure the administrative link password correctly?

If so, try to create a local distributor on the current publisher to make
sure it is working correctly. Then disable it and use the remote publisher.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Dear All,
> I am trying to put distirbuter and subscriber on the same SQL Server
[quoted text clipped - 14 lines]
>
> Regards
laststubborn - 30 Jun 2006 16:01 GMT
Thank you very much I solved the problem by using Error 14114 solution
from Microsft eventhough they are not realted. :)
regards
ls

> Did you configure the administrative link password correctly?
>
[quoted text clipped - 33 lines]
> >
> > Regards
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.