Microsoft SQL Server Discovery Errors

We have a discovery configured with over 20 SQL servers and instances covering many more databases, everything works perfectly bar one SQL server.  We continue to get the errors after upgrading Enterprise Reporter now several times (now at, and have recently built a new SQL server (from 2014 to 2019) and moved the databases across.

We get a collection of the errors below that I can’t find any reference to in the knowledge base, and there are no errors in the ER discovery logs.

Does anyone have any idea as to what this could be or I could being to investigate these messages?

Needless to say, the databases have valid owners, the applications running on the databases run perfectly well, the SQL logins are linked to database user where appropriate and all security applied functions as it should.  Of note, the databases that don't give us the SQL_Determining_owner error all have domain accounts as owners.


ObjectTypeId: SQL_Database


ExceptionMessageNo mapping between account names and security IDs was done



ExceptionMessageObject reference not set to an instance of an object.






ExceptionMessageObject reference not set to an instance of an object.




ExceptionMessageArray dimensions exceeded supported range.