Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: moudar123 on July 07, 2021, 04:35:14 PM

Title: SQL query problem
Post by: moudar123 on July 07, 2021, 04:35:14 PM
Hi
When trying to install the server i get this meesage!
I am a beginner so all thoughts are welcome.
Title: Re: SQL query problem
Post by: Egert143 on July 07, 2021, 07:35:22 PM
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 (https://stackoverflow.com/questions/17115632/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive)
Title: Re: SQL query problem
Post by: moudar123 on July 07, 2021, 10:52:35 PM
Thanks for answer!
I am using database driver mssql.ddr not ODBC.ddr
why i am getting error about ODBC?
Title: Re: SQL query problem
Post by: Victor Kirhenshtein on July 09, 2021, 04:22:11 PM
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
Title: Re: SQL query problem
Post by: moudar123 on July 10, 2021, 01:33:41 PM
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
Title: Re: SQL query problem
Post by: Victor Kirhenshtein on July 12, 2021, 05:40:17 PM
You have to install  SQL Server Native Client on machine where you are installing NetXMS server.

Best regards,
Victor
Title: Re: SQL query problem
Post by: moudar123 on July 13, 2021, 09:10:50 AM
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?
Title: Re: SQL query problem
Post by: Victor Kirhenshtein on July 13, 2021, 09:23:53 AM
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 (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 (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-client-protocols?view=sql-server-ver15).

Best regards,
Victor
Title: Re: SQL query problem
Post by: moudar123 on July 13, 2021, 09:50:55 AM
both are enabled but same problem still there!
Title: Re: SQL query problem
Post by: moudar123 on July 13, 2021, 09:52:18 AM
Maybe it is named pipes i need to enable
i will test! :-)
Title: Re: SQL query problem
Post by: moudar123 on July 13, 2021, 09:59:32 AM
Still same problem!
Title: Re: SQL query problem
Post by: Victor Kirhenshtein on July 13, 2021, 11:04:07 AM
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
Title: Re: SQL query problem
Post by: moudar123 on July 13, 2021, 11:54:28 AM
it is working now
it was wrong IP address
it is not local machine but another one :-)

thank you for help
Text only | Text with Images