000032268 - Error occurred while creating an ODBC connection for DSN. How to fix ODBC Connection to Database on RSA Secutity Analytics Appliance10.5.0

Document created by RSA Customer Support Employee on Jul 7, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032268
Applies ToRSA Product Set: Security Analytics
RSA Product/Service Type: SA Security Analytics Server / SA Log Collector
RSA Version/Condition:
Platform: CentOS
O/S Version: 6
IssueWhile creating and ODBC connection to database on SA below error shows up:
Test connection failed:Error! An error occurred creating an ODBC connection for DSN: Mcafee_MVM The trapped error is: 
Unable to create an ODBC connection. DSN: Mcafee_MVM; username: RSAfaultline; reason: state: 08S01;
error-code: 0; description: [RSA][ODBC SQL Server Wire Protocol driver]Socket closed.

CauseNormally the “Socket error” message in MSSQL indicates a network related issue from MSSQL Instance. MSSQL 2005 uses Encryption by default which could be the cause of this and Encryption from MSSQL 2008 onwards is disabled by default.
ResolutionIn order to try to fix the issue the below steps needs to be performed: 
1- Connect to MSSQL server , Click Start, in the Microsoft SQL Server 2005/2008 program group, expand Configuration Tools menu, and then click SQL Server Configuration Manager. 
2- Expand SQL Server Network Configuration, right-click the protocols for the server you want, and then click Properties. 
3- On the Flags tab, view or specify the protocol encryption option. In our case we need to disable it by setting it to "No".
4- Restart SQL Server Engine by selecting "SQL Server Services" in right panel and right click on "SQL Server" and then select restart. 
5- Stop/Start ODBC collection on LogCollector/VLC Device from SA GUI