Error occurred while creating an ODBC connection for DSN. How to fix ODBC Connection to Database on RSA Secutity Analytics Appliance10.5.0
Originally Published: 2015-12-23
Article Number
Applies To
RSA Product/Service Type: SA Security Analytics Server / SA Log Collector
RSA Version/Condition: 10.5.0.0
Platform: CentOS
O/S Version: 6
Issue
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.
Cause
Resolution
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
Related Articles
Questions on creating an AFX connector to PostgreSQL using a generic ODBC driver in RSA Identity Governance & Lifecycle Number of Views Test connection failed. One or more directory connections is incorrect error during testing connection from RSA Authentica… Number of Views Error message "The underlying connection was closed: An unexpected error occurred on a send" when trying to run RSA Authen… Number of Views LDAP authenticator based on Active Directory Identity Collector fails with the error 'Connection could not be established … Number of Views Unable to create connection to the database using Oracle 12 pluggable database as remote database on RSA Via Lifecycle & G… Number of Views
Trending Articles
RSA Authentication Manager Patch Updates RSA Authentication Manager 8.9 Release Notes (January 2026) Unification is failing at step 8 on "AVUSER.ROLE_MANAGEMENT_PKG", line 2469 in RSA Governance & Lifecycle How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle RSA Announces the Release of RSA MFA Agent 2.5 for Microsoft Windows
Don't see what you're looking for?
