dbTalk Databases Forums  

Unable to publish a database for replication

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Unable to publish a database for replication in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
RODOLFO
 
Posts: n/a

Default Unable to publish a database for replication - 07-06-2005 , 10:25 AM






Hello all.

When I use the New Publication Wizard, I get this message:

---
Error 21423: You do not have sufficient privileges to view the publication
information. Your administrator may need to fix the PAL role on the publisher
for publication 'name'.
---

This only happens with a particular database...

While in the publication wizard there is a slight difference: after the
screen where you select the articles to be published, I get 2 messages with
the 'name' database:

-----------
1- Uniqueidentifier columns will be added to tables.
2- IDENTITY columns require the NOT FOR REPLICATION option.
------------

With all the other databases, I only get the 2nd message above at this step.

Any hint?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.