We would like to add a feature to Monitor the SQL connection and version of the software periodically and remotely.
We would like to Programmatically call the 4 Test Connection steps below
1. Can BI Collector Connect to Server
2. Validate the SQL Server Version
3. Verify Access to Database
4. Verify Database Schema Version
5. Validate Version of BI Collector