Problem publishing. Was Error 21423......

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
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
|||Hi and thanks.
I am logged as the system administrator and Enterprise Manager is using the
sa account. I am able to publish almost every database, but not this one.
"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...
> publisher
>
>