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 On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up Number of Views Add, Delete, and Test the Connection for an Identity Source in Cloud Access Service Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Upgrade Process Downloading RSA Authentication Manager license files or RSA Software token seed records Artifacts to gather in RSA Identity Governance & Lifecycle RSA Announces Availability of RSA Authentication Manager 8.8 Language Packs and Nutanix AHV Support
Don't see what you're looking for?
