Updated from 3.x to 4 - insufficient credentials error now

joshuawfergusonjoshuawferguson Posts: 9 Bronze 1
Since updating to SQL Monitor 4 I'm having trouble getting monitoring working again. As far as I can tell using Redgate's official documentation, I have the SQL account permissions set correctly, yet the log shows this:
The INSERT permission was denied on the object 'redgate_sqlmonitor_topqueries_b_lftcadsrv.(local)_redgate-sql', database 'tempdb', schema 'dbo'.

I added db_datareader and db_datawriter permissions to the account, and monitoring resumed fine. Is there something I'm missing that may have caused this error? Thanks.


Sign In or Register to comment.