Roadmap Servers Alive v8 The SQL addon was only created for SQL2005 and SQL2008, not for SQL2012 and won't work with it. You could try the ODBC checker (assuming you have an ODBC driver (32 bits!) installed on the system running SA for SQL2012). On the roadmap for Servers Alive v8 there is a new SQL checker that will use SQL SMO (or maybe WMI) and that will be able to check SQL2012. The current SQL checker that is part of Servers Alive is based on the obsolete SQL DMO technology. dirk.
-------------------------------------------------------------------------------- From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On Behalf Of Schaeffer, Bruce Sent: Thursday, June 11, 2015 8:00 PM To: Servers Alive Discussion List Subject: [SA-list] Trouble Monitoring SQL Server 2012 Databases I’m having trouble monitoring databases running on SQL Server 2012. This is the first time I’m trying to monitor SQL Server 2012. Background: OS is Windows 7 Enterprise, 32-bit, (Build 7601, Service Pack 1). Servers Alive version is 7.0.2505. Using External COM; SQL Server checker (don’t know version number). I’m able to monitor databases on SQL Server 2008. I’m trying to monitor two databases, each one on its own server, let’s call them ServerA and ServerB. Both are running SQL Server 2012 version 11.0.5058. ServerA’s message is “ERR: Requested value ‘Version110’ was not found.(at 270)”. ServerB’s message is “ERR: Exception has been thrown by the target of an invocation.(at 270)” I’ve confirmed that I can access the tables within each database using Microsoft SQL Server Management Studio from my office PC with the credentials entered into the COM check. Any ideas how to diagnose this? Thanks, Bruce ------------------------------------------------------------------------- Bruce B. Schaeffer Systems Engineer Middlesex County College 2600 Woodbridge Ave. Room JLC209 Edison, NJ 08818-3050 Voice +1.732.906.2607 Fax +1.732.548.6814 bschaef...@middlesexcc.edu (UrlBlockedError.aspx) ------------------------------------------------------------------------- To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
