The EXECUTE permission was denied on the object 'xp_regread', database 'mssqlsystemresource', schema 'sys'.

Receiving 'xp_regread' error as soon as connected to SQL Server Management Studio.

OR

Execution of SSIS packages from SQL jobs fails with error: The EXECUTE permission was denied on the object 'xp_regread', database 'mssqlsystemresource', schema 'sys'

Solution:

To connect and to view the SQL Server Agent:

USE [master]
GO
GRANT EXECUTE ON xp_regread TO [public]
GO


To Execute Job:


-->

USE [master]

GO

GRANT EXECUTE ON xp_sqlagent_enum_jobs TO [public]

GO