I have the agent deployed to a SQL error I am monitoring, I’ve tried to collect the data to see what audit information has been captured.
SQLcompliance agent is throwing up application event errors, I think it’s something to do with accessing a stored procedure that doesn’t exist.
“You cannot create procedures on MASTER – DBA must disable trigger “NoCreateProcs” to do this!”
“Error: An error occured setting stored procedure permissions. Name = sp_SQLcompliance_StartUp.
Exception: Cannot find the object ‘sp_SQLcompliance_StartUp’, because it does not exist or you do not have permission.”
We are on version 4.2.204.0 of the agent and software.
I can see an agent trace files folder on the monitored server.