Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Line 53
- From: "dONALD" <donald@xxxxxxxxxx>
- Date: Fri, 22 Apr 2005 15:03:42 -0400
Hello everyone,
I am a newbie on replication, I attempte to set up Transactional Replication
with remote distributor between 2 servers (Server1 as Publisher and Server2
as Distributor and Subscriber). From the Configure Publisher and
Distributor wizard, it indicates distributor was properly configured, but
when ever I attemp to enable Publication, it gives me the following message:
Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Line 53
The Distributor has not been installed correctly. Could not enable database
for publishing.
The replication option 'publish' of database 'MyDB' has been set to false.
When I attempt to run the following command from Query Analyzer, it gives
the same message
sp_replicationdboption @dbname = 'MYDB'
@optname = 'publish' ,
@value = 'true'
Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Line 53
The Distributor has not been installed correctly. Could not enable database
for publishing.
The replication option 'publish' of database 'MYDB' has been set to false.
Please let me know what did I missed.
Part 1 - Configuring Distributor and Publisher:
- Have both Servers running under same domain service account, able to
access the UNC snapshot share from both servers.
- Create the distributor_admin account on both Servers.
- Define Remote Server using ServerName on both servers.
- Define Distributor from Server2 using Configure Publishing and Distributor
wizard, select its own as Distributor, and use the UNC share for snapshot
folder (\\Server2\ReplData)
- Enable Server1 as Publisher, use Impersonate the SQL Server Agent account
(Trusted Connection) to connect to the Publisher, and use the
distributor_admin password to establish a link to the Distributor.
- Enable the Publication database on Server1 'MyDB' with Transactional.
- Enable Server2 as subscriber, with Impersonate the SQL Server Agent
account on 'Server1' (trusted connection).
All above steps completed successfully
Part 2 - Create and Manage Publications on Server1:
- Select 'MyDB' as Transactional publication.
- Select SQL Server 2000 as Subscriber Type.
- Select the tables to be replicated.
- Define 'MyDB' as publication name.
- Proceed creating the publication, and gives error 20028
Thank you in advance!
Donald
.
- Follow-Ups:
- RE: Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Li
- From: Donna Lambert
- RE: Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Li
- Prev by Date: Re: Stored Procedure Error
- Next by Date: Re: MS_REPLERRORS
- Previous by thread: 1 transaction with 800000 commands were delivered
- Next by thread: RE: Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Li
- Index(es):
Relevant Pages
|
