"RODOLFO" <RODOLFO@discussions.microsoft.com> wrote in message
news:8D8429D9-95D7-4D54-9D4C-4936CECC6F12@microsoft.com...
> Hi all.
> Im trying to set up replication from Enterprise Manager to one of my
> databases. I have successfly done it for the Northwind database in this
> server but now I get this error when trying to do it for another database.
>
> The complete error message I get when I click on the Finish button of the
> wizard is:
>
> ---
> 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 'database_name'.
> ---
> The only difference I've found between the Northwind database and this
> database is a Role present in Northwind: MSmerge_1C6CDE.....something that
> looks like a GUID.
>
> Any ideas?
>
> Thanks in advance for your help,
>
> RODOLFO

"Hilary Cotter" wrote:

> something is very wrong here. Are you logged on as the system administrator
> when you are trying to create this publication? Do you have this problem
> with other databases?
>
> The MSMerge_14245 account is used by the PAL, it should be present when you
> successfully create a publication.
>
> --
> Hilary Cotter
> 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
> "RODOLFO" <RODOLFO@discussions.microsoft.com> wrote in message
> news:8D8429D9-95D7-4D54-9D4C-4936CECC6F12@microsoft.com...
> > Hi all.
> > Im trying to set up replication from Enterprise Manager to one of my
> > databases. I have successfly done it for the Northwind database in this
> > server but now I get this error when trying to do it for another database.
> >
> > The complete error message I get when I click on the Finish button of the
> > wizard is:
> >
> > ---
> > 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 'database_name'.
> > ---
> > The only difference I've found between the Northwind database and this
> > database is a Role present in Northwind: MSmerge_1C6CDE.....something that
> > looks like a GUID.
> >
> > Any ideas?
> >
> > Thanks in advance for your help,
> >
> > RODOLFO
>
>