I am trying to integrate MSsql and did all the setting as per device configuration guide, added dsn in SA and restarted the odbc but getting an error like :- tail -f /var/log/messages
[OdbcCollection] [failure] [mssql.MSSQL] [processing] [MSSQL] [processing] An error occurred creating an ODBC connection.#011 The DSN for this connection is: MSSQL The trapped error is: Unable to create an ODBC connection. DSN: MSSQL; username: audit_reader; reason: state: 08001; error-code: 0; description: [RSA][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
Mar 27 14:00:26 CHEETAH-VL-12 NwLogCollector[23476]: [OdbcCollection] [failure] [mssql.MSSQL] [processing] [MSSQL] [processing failure] odbc:WrkUnit[2] Processing failed.
DSN:-
[MSSQL]
Driver=/opt/netwitness/odbc/lib/R3sqls26.so
Port=1782
hostname=100.100.100.1
database=MSSQL
Kindly help to resole this issue...
Hi Sachin,
I have moved this thread to the RSA NetWitness Platform community so that you can get an answer to your question.
Thanks,
Jeff