NetXMS Support Forum

Hi
When trying to install the server i get this meesage!
I am a beginner so all thoughts are welcome.

Hello

It means that ODBC driver is missing, need to install it seperately. Some info: https://stackoverflow.com/questions/17115632/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive

Thanks for answer!
I am using database driver mssql.ddr not ODBC.ddr
why i am getting error about ODBC?

Hi,

error message is like this because MS SQL driver uses ODBC API internally. Do you have MS SQL native client installed on the server?

Best regards,
Victor

this is the copy of SQL that i am using:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)   Aug 22 2017 17:04:49   Copyright (C) 2017 Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

Should i try to install SQL Server Native Client on the same server ?

Best regards

You have to install  SQL Server Native Client on machine where you are installing NetXMS server.

Best regards,
Victor

I did install SQL Server Native Client on machine where i am installing NetXMS server.
But a new error message started to appear!
Any ideas?

Hi,

you have to enable TCP/IP for both client and server. Those are relevant documentation pages: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15 and https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-client-protocols?view=sql-server-ver15.

Best regards,
Victor

both are enabled but same problem still there!

Maybe it is named pipes i need to enable
i will test! :-)

Still same problem!

How did you specify server address? Try to use local IP address (127.0.0.1) instead of server name (I assume SQL server is on same machine).

Best regards,
Victor

it is working now
it was wrong IP address
it is not local machine but another one :-)

thank you for help