Error: “Unable to execute ‘select srvname, Cast (SERVERPROPERTY(‘ProductVersion’) as varchar) from sys.sysservers’:Invalid”

“Unable to execute ‘select srvname, Cast (SERVERPROPERTY(‘ProductVersion’) as varchar) from sys.sysservers’:Invalid” when Diagnostics8.0 collector connects to SQL 2000 to collect the metrics

Existing database is not compatible with diagnostic collector 8.0

Diagnostic 8.0 collector does support SQL 2005 and SQL 2008 connections ONLY.

Leave a Comment