Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community
The EXECUTE permission was denied on xp_msver
Published Mar 15 2019 01:06 PM 14.1K Views

First published on MSDN on Jan 24, 2017
Recently after installing SQL Server and configuring SSIS for project deployment in a SQL Server 2012 environment, a customer was experiencing issues when attempting to execute a package deployed to the Integration Services catalog or through SQL Agent calling the package. Developers' accounts were working correctly, however this issue would occur when attempting to execute via a functional service account. After clicking Edit on the job step properties screen or opening the Execute screen in the catalog, the following error message would be displayed:



“The EXECUTE permission was denied on the object ‘xp_msver’, database mssqlsystemresource’, schema ‘sys’. (Microsoft SQL Server, Error: 229)” A quick check of books online indicates that the only necessary permissions needed for this object are public. A permissions check for the functional user indicated that they were already set with the public role. A fix for this issue is to grant execute permissions on the object explicitly for that object.

USE msdb;
GO
GRANT EXECUTE ON sp.xp_msver TO [Domain\Account]
GO

 

Version history
Last update:
‎Apr 28 2020 01:35 PM
Updated by: