SQL server

EXECUTE permission was denied on the object ‘xp_logevent’

If you are faced with a similar error below:

The EXECUTE permission was denied on the object ‘xp_logevent’, database ‘mssqlsystemresource’, schema ‘sys’

A quick fix can be used. Please make sure there are no security concerns with granting this access to the respective account. There will an account that is running a script that is returning this error. Let’s say that account is domain\user. Run the query:  grant execute on xp_logevent to [domain\user] in the context of the master DB.

This should resolve the issue.

Advertisements
Standard

Thinking about someting? Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s