NetXMS Support Forum

Dear all.

We have searched this forum and tried several things but it is not working anyway. We try to install a complete new NetXMS and want to use our MS SQL Server behind it.

NetXMS Server Details
OS: Windows Server 2016 Datacenter
NetXMS Version: 4.4.4

SQL Server Details
OS: Windows Server 2016 Datacenter
SQL Version: SQL Server Standard 2016 (Version 13.0.1742.0)
Named Pipes & TCP/IP: Enabled

We are using this SQL server vor several services and it is working properly. We even installed the MS SQL Native Client on the NetXMS Server, but this also didn't help. The configuration of an odbc connection via this native client works properly (see screenshot).

Attached you can find some screenshots of installation etc. We use full installation with tick mark on initialize database. Furthermore it happens also when I use IP address instaed of server name.

Config file netxmsd.conf
#
# Configuration file generated on Thu Nov 30 11:39:15 2023
#

DBDriver=mssql.ddr
DBServer=VM-EGB-SQL01
DBName=NETXMS
DBLogin=sa
DBPassword=***********
LogFile=C:\NetXMS\log\netxmsd.log

Logfile netxmsd.txt:
2023.11.30 11:37:35.365 *I* [logger             ] Log file opened (rotation policy 2, max size 16777216)
2023.11.30 11:37:35.365 *I* [startup            ] Starting NetXMS server version 4.4.4 build tag 4.4-730-g20b6ebeb8a
2023.11.30 11:37:35.365 *I* [logger             ] Debug level set to 0
2023.11.30 11:37:35.365 *I* [config             ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.11.30 11:37:35.365 *I* [config             ] Configuration tree:
2023.11.30 11:37:35.365 *I* [config             ] config
2023.11.30 11:37:35.365 *I* [config             ]  +- server
2023.11.30 11:37:35.365 *I* [config             ]      +- DBDriver
2023.11.30 11:37:35.365 *I* [config             ]      |    value: mssql.ddr
2023.11.30 11:37:35.365 *I* [config             ]      +- DBServer
2023.11.30 11:37:35.365 *I* [config             ]      |    value: VM-EGB-SQL01
2023.11.30 11:37:35.365 *I* [config             ]      +- DBName
2023.11.30 11:37:35.365 *I* [config             ]      |    value: NETXMS
2023.11.30 11:37:35.365 *I* [config             ]      +- DBLogin
2023.11.30 11:37:35.365 *I* [config             ]      |    value: sa
2023.11.30 11:37:35.365 *I* [config             ]      +- DBPassword
2023.11.30 11:37:35.365 *I* [config             ]      |    value: ********
2023.11.30 11:37:35.365 *I* [config             ]      +- LogFile
2023.11.30 11:37:35.365 *I* [config             ]           value: C:\NetXMS\log\netxmsd.log
2023.11.30 11:37:35.365 *I* [db.drv             ] Database driver "mssql.ddr" loaded and initialized successfully
2023.11.30 11:37:35.412 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.11.30 11:37:35.412 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.11.30 11:38:00.443 *E* [db                 ] Unable to establish connection with database ([Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben) Error means in English: Data source name not found and no default driver specified

I hope that there is sb who can help us. Why has NetXMS problems to connect to our db?

Best regards Oli