AnsweredAssumed Answered

MSSQL Integration Issue

Question asked by sachin sahu on Mar 27, 2017
Latest reply on Mar 29, 2017 by Arthur Costigan
  • Comment • 2

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

No one else has this question

Outcomes