vluu Posted May 8, 2014 Report post Posted May 8, 2014 Hi, My SMS_DISCOVERY_DATA_MANAGER component status is showing as critical because Meesage ID 619 is being logged every minute. Any advice what is causing this, how to fix and if this would impact the application? Status Message Details as follows: Microsoft SQL Server reported SQL message 229, severity 14: [42000][229][Microsoft][sql Server]The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'. : sp_executesqlPlease refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information. Thx Quote Share this post Link to post Share on other sites More sharing options...
Peter van der Woude Posted May 9, 2014 Report post Posted May 9, 2014 As it's every minute and marked as critical then, yeah, that will impact the application... Especially looking at the error, it seems a problem on your database (permissions). Quote Share this post Link to post Share on other sites More sharing options...
