Hi Support Team,
I am getting the below after I upgraded my Idera SQL DM version from 10.0 to 10.4. I am getting the below alerts for two servers which are running SQL 2000 SP2. Please let me know if there is any fix to clear this alert or is there any other alternative. Please let me know if you need any additional details too.
11/7/2019 9:52:32 PM, SQL Server Status on <servername.domain> is Critical.
SQL Server instance servername.domain - The SQL Server service status is: Unable To Monitor.
[servername.domain] Error executing Server Details Collector: 'IS_ROLEMEMBER' is not a recognized function name.
SQL Server Status: Status of the SQL Server service.
I think you already contacted Tech Support, but for issues like this one you should email email@example.com. You can also create a case directly on the customer portal, call us at 713-533-5144, or reach us through chat on the Idera website (this last during daytime hours only).
Thanks Scott. Yes, I sent a mail to firstname.lastname@example.org and their response was to update Idera with the service pack (10.4.2). I also observed that the charts and counters for the SQL 2000 instances were not showing any information and observed lot of errors when the charts are trying to refresh. Shared the detailed error list to the support team and awaiting for their response.