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 Add, Delete, and Test the Connection for an Identity Source in Cloud Access Service Number of Views Connection to Cloud Authentication service via Security Console fails with an error; ""Failed to register to the Cloud Aut… Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records Unable to login to RSA Authentication Manager Security Console as super admin RSA Authentication Manager 8.9 Release Notes (January 2026) How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Connection fails to Cloud Authentication Service when connecting through a proxy server from RSA Authentication Manager to…
Don't see what you're looking for?
