|Applies To||RSA Product Set: Security Analytics|
RSA Product/Service Type: SA Security Analytics Server / SA Log Collector
RSA Version/Condition: 10.5.0.0
O/S Version: 6
|Issue||While creating and ODBC connection to database on SA below error shows up:|
Test connection failed:Error! An error occurred creating an ODBC connection for DSN: Mcafee_MVM The trapped error is:
|Cause||Normally the “Socket error” message in MSSQL indicates a network related issue from MSSQL Instance. MSSQL 2005 uses Encryption by default which could be the cause of this and Encryption from MSSQL 2008 onwards is disabled by default.|
|Resolution||In order to try to fix the issue the below steps needs to be performed: |
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