MSSQL Integration Issue

[sachinsahu]

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... 

[jeffshurtliff]

Hi Sachin,

I have moved this thread to the https://community.rsa.com/community/products/netwitness?sr=search&searchId=4d50517b-6a25-4fbc-99ae-a71d4ef9adbb&searchIndex=0‌ community so that you can get an answer to your question.

Thanks,
Jeff

[ArthurCostigan1]

Sachin,

This error happens because Netwitness cannot connect to MSSQL.  

I noticed in your snippet the port being reported back by Netwitness is 1782.  Do you have port 1782 listening on the MSSQL server for the Netwitness connection?