Event ID - 21049

Event Id21049
SourceMSSQLServer
DescriptionThe login %s does not have access permission on publication %s because it is not in the publication access list.
Event InformationCAUSE:
When you create a publication, Microsoft SQL Server creates a publication access list (PAL) for the publication. The PAL contains a list of logins that are granted access to the publication. You received this error because the current login is not in the PAL for the publication on which you are trying to perform the requested operation. Please refer to the Books Online topic, "Publication Access Lists."

RESOLUTION:
To add or delete logins in the PAL for any publication, use SQL Server Enterprise Manager or the sp_grant_publication_access and sp_revoke_publication_access stored procedures.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 21049

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.