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'”

AWS/RDS – SQL Server – Error – “The EXECUTE permission was denied on the object ‘agent_datetime’, database ‘msdb’, schema ‘dbo’ “

Background Here is an error I have been wanting to talk about for a while here. Code msdb.dbo.agent_datetime Outline The agent.date_time function accepts two integer values, date and time. And, returns the corresponding datetime value. SQL Output Output - AWS Here is the result when we issue command against an ASW/RDS MS SQL Server Instance. … Continue reading AWS/RDS – SQL Server – Error – “The EXECUTE permission was denied on the object ‘agent_datetime’, database ‘msdb’, schema ‘dbo’ “