SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”

Background When SQL Server Management Studio ( SSMS ) is ran against an Amazon/RDS SQL Server instance, we can get a little error. Error The error reads :- Error Message Image Text Error Message - Advanced Information Image Text Explanation Looking at the Stack Trace the error occurs at :- Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName() TroubleShooting What is the … Continue reading SSMS – AWS/RDS – Error – “The EXECUTE permission was denied on the object ‘xp_regread'”