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

SQL Server Best Practice Analyzer (BPA) – v2012 – Against SQL Server v2014 and Beyond

Background There are a couple of things one needs to do to get "SQL Server Best Practice Analyzer" (BPA) v2012 to work against MS SQL Server v2014 and above. In an earlier post we discussed how we determined that we need to have "SQL Server Shared Management Objects" (SMO) installed.   Guidelines Copy SQL2012BPA Copy SQL2012BPA … Continue reading SQL Server Best Practice Analyzer (BPA) – v2012 – Against SQL Server v2014 and Beyond