Actions

Tags

Darren Mallette
Jun 27, 2017
Setting up Foglight when SQL Server wants SSL

Updated in March 2021 -

You now only need to check the "Use SSL" box when setting up your SQL Server connections in Foglight. This option appeared in the 5.9.x line of releases.

A customer recently had this error message when trying to monitor a new SQL Server instance:

Reason : [Foglight][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.

They didn't want to disable the requirement for an SSL connection, so we followed the following steps. Thanks to  for the tip!

Start by selecting the option to discover multiple SQL Server instances:

Select the Foglight Agent Manager you wish to run the agent from, and validate it.

Select Add Instances and Add Manually.

Enter the host\instance name in the popup window. Next, select the instance, and set credentials.

Set the SSL Connection pulldown to mandatory. Enter DB credentials and other options (OS/PI) and click Monitor.

Anonymous
Parents
  • over 6 years ago

    Hi Darren,

    Good article - helped me get the inital setup of ssl to sql db setup, but when foglight tries to connect to SQL 2016, we get the following initialise error in the floglight web gui:

    Failed to establish a SQL-Server JDBC connection protocol to Host [bisqlcluster.xxxxxxxx.com\DEFAULT_INSTANCE], user account [xxxxxxxxx\username] . Reason : [[Foglight][SQLServer JDBC Driver]SSL handshake failed: Unsupported curveId: 29- Profile:MSSQLProfile{host='bisqlcluster.xxxxxxx.com', instance= 'DEFAULT_INSTANCE', username='xxxxxxxxx\username', authType= 'WINDOWS_CUSTOM', port= '0' useNTLMv2= 'true', socketTimeout= '900', secureConnection= 'REQUIRE', packetSize= '0' }]. . [SQL-Server Error Code = 0. SQL state : 08001]

     

     

     Am I missing something?

    Kind regards,

    Jonathan

     

Comment
  • over 6 years ago

    Hi Darren,

    Good article - helped me get the inital setup of ssl to sql db setup, but when foglight tries to connect to SQL 2016, we get the following initialise error in the floglight web gui:

    Failed to establish a SQL-Server JDBC connection protocol to Host [bisqlcluster.xxxxxxxx.com\DEFAULT_INSTANCE], user account [xxxxxxxxx\username] . Reason : [[Foglight][SQLServer JDBC Driver]SSL handshake failed: Unsupported curveId: 29- Profile:MSSQLProfile{host='bisqlcluster.xxxxxxx.com', instance= 'DEFAULT_INSTANCE', username='xxxxxxxxx\username', authType= 'WINDOWS_CUSTOM', port= '0' useNTLMv2= 'true', socketTimeout= '900', secureConnection= 'REQUIRE', packetSize= '0' }]. . [SQL-Server Error Code = 0. SQL state : 08001]

     

     

     Am I missing something?

    Kind regards,

    Jonathan

     

Children
No Data
Related Content