Receiving SSL Security Error When Connecting to GP using the GP Adapter

Receiving SSL Security Error When Connecting to GP using the GP Adapter

book

Article ID: KB0076321

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight -

Description

If your GP database server only has TLS 2.0 enabled you may receive an SSL Security error when trying to connect using the GP adapter from TIBCO Scribe® Insight

Issue/Introduction

When connecting to GP using the GP Adapter in TIBCO Scribe® Insight and SSL Security error is received

Resolution

The GP Adapter uses a Native SQL connection to connect therefore in order to resolve this issue the TIBCO Scribe® SQL Server Template ODBC Connection will need to be re-created and use a different driver that supports only having TLS 2.0 enabled.
  1. First you will need to make sure that the updated OLEDB driver is installed on the TIBCO Scribe® Insight Application server:  https://www.microsoft.com/en-us/download/details.aspx?id=56730
  2. Using C:\Windows\System32\odbcad32.exe. (for 32-bit system) On System DSN tab, rename the old Scribe® SQL Server Template DSN (e.g. Scribe SQL Server Template to Scribe SQL Server Template2)
  3. Add a new System DSN with the same name as the original DSN (e.g. Scribe SQL Server Template)
  4. Select the ODBC driver 13 for SQL Server or SQL Server Native Client 11.0
  5. Enter the name of the server (where ScribeInternal Database is installed)
  6. Select SQL Authentication authorization type (For SQL Authentication the username/password is typically SCRIBE/integr8!)
  7. Choose the defaults for the rest of the fields.
Once you complete the above steps the GP connection using the GP adapter should connect without issue
 
Powered by Wolken Software