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 3.2.2.336), 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
MessageId: SQL_Determining_owner
ExceptionMessage: No mapping between account names and security IDs was done
ObjectTypeId: SQL_Login
MessageId: SQL_Discovering_implicit_login_information
ExceptionMessage: Object reference not set to an instance of an object.
ObjectTypeId: SQL_Role_Member
MessageId: SQL_Login_for_Role_Member_could_not_be_found
ExceptionMessage: NULL
ObjectTypeId: SQL_SQL_Server
MessageId: SQL_Retrieving_logins
ExceptionMessage: Object reference not set to an instance of an object.
ObjectTypeId: SQL_User
MessageId: SQL_Discovering_database_user
ExceptionMessage: Array dimensions exceeded supported range.
