An error occurred creating an ODBC connection for DSN in RSA Security Analytics

Issue

Test connection failed:Error! An error occurred creating an ODBC connection for DSN: SIte_Protector The trapped error is:

 Unable to create an ODBC connection. DSN: SIte_Protector; username: admin; reason: state: 08001; 
error-code: 0; description: [RSA][ODBC SQL Server Wire Protocol driver]Invalid Connection Data”

Cause

What causes the issue is the entry on the DSN (on the SA GUI -> event source -> ODBC -> DSN) has wrong entries

Resolution

Make sure the following entry on DSN (on the SA GUI -> event source -> ODBC -> DSN) is correct as below -

 Database=<Specify the database used by RealSecure>
 
PortNumber=<Specify the Port Number, default is 1433>
 
HostName=<Specify the hostname or IP Address of RealSecure>
 
Driver=/opt/netwitness/odbc/lib/R3sqls26.so

For 10.6.2 and newer, use /opt/netwitness/odbc/lib/R3sqls27.so
For 10.6.1 and older, use /opt/netwitness/odbc/lib/R3sqls26.so

Product Details

RSA Product Set: RSA Security Analytics
RSA Product/Service Type: Log Collector
RSA Version/Condition: 10.4.x,10.5.x,10.6.x
Platform: CentOS
O/S Version: EL6

Approval Reviewer Queue

Technical approval queue