For our next steps we suggest two options to enable monitoring to work:
1) If SSL is enabled on the SQL Server host, apply Cumulative update package 3 for SQL Server 2008 SP3 -
https://support.microsoft.com/en-us/kb/2648098, ensure a post update reboot occurs and then we can try using the SSL manditory or required setting again
or
2) Disable SSL Forced Encryption on the MSSQL server (this probably may not be an option), restart the MSSQL server and then using the SSL connection turned off in the agent.
3) In addition, the user can run the following query from SQL Server Management Studio to see if there are any encrypted connections on the SQL Server as well. If 0 is returned, it is most likely that the setting for “Force Encryption” is “No”.
SELECT count (encrypt_option)
FROM sys.dm_exec_connections
WHERE encrypt_option = 'TRUE'
1. Remote Desktop to your SQL Server host
2. Open SQL Server Configuration Manager
3. Expand SQL Server Network Configuration section and right-click on the Protocols for <instance name> and select Properties
4. Force Encryption is under Flags tab (No by default)
5. If it is set to No, then we will need to set the SSL Connection in Foglight’s Agent Status Properties of the agent to OFF
Please, click on Database dashboard | select the instance | Settings | Administration | Connection Details | set the SSL connection to "OFF, Mandatory, Optional" based on your preference | click on Set | click on Validate Connectivity | click on the Save Changes button.
