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 LDAP authenticator based on Active Directory Identity Collector fails with the error 'Connection could not be established … Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
