Setup not going through with SQL Server

[Filipp Sudanov]

Do you actually have MS SQL database installed?

[eliassal]

Yes of course, it is a remote named instance sql server (as you can notice in the text where I indicated the name of SQL server

Unable to connect .... server SQL2K12\SC2K12,

not on the machine where I am installing netxms, even I created manullay NetMXS DB and a user and granted it dbcreator privileges

[gmonk63]

Can you connect to the instance remotely via SQL Management Studio.  I believe you have to allow  remote access and make sure its able to listen on the default 1433 port

[eliassal]

I can ping the host and connect to the default and named instance from anywhere in my network. NeyXNS is setup on a new brand fresh win 10 VM, in case you mean SSMS on this VM no It is not setup and I think that NetMXS setup will install necessary libraries to access SQL default or named instance

[Filipp Sudanov]

I did not test this, but probably it does not support format with \ in the database address field. Try just IP address there.

Anyways, all that the installation wizard does is creating C:\NetXMS\etc\netxmsd.conf and launching
nxdbmgr init
(which is located in C:\NetXMS\bin).

So you can adjust the .conf file and run nxdbmgr init manually. When it succeeds, you can start Netxms Core service.

[eliassal]

Hi Filipp, I already tried with another sql server default installation, not a named instance (without the /), same issue happened

[eliassal]

Filipp, I have just tried all possibilities with the command, default instance DB host name , IP, named instance ip/named instance

nxdbmgr check

I get the same exact error as you can notice for the 4 tests

NetXMS Database Manager Version 3.9.298 Build 3.9-298-g2adbdd51e5 (UNICODE)

Unable to connect to database NetXMS@SQL2K12\SC2K12 as netxms ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)

C:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 3.9.298 Build 3.9-298-g2adbdd51e5 (UNICODE)

Unable to connect to database NetXMS@SQL2K12 as netxms ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)

C:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 3.9.298 Build 3.9-298-g2adbdd51e5 (UNICODE)

Unable to connect to database [email protected]\SC2K12 as netxms ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)

C:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 3.9.298 Build 3.9-298-g2adbdd51e5 (UNICODE)

Unable to connect to database [email protected] as netxms ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)

And here you can see that pining the sql server works fine

Pinging sql2k12.salam.net [192.168.1.69] with 32 bytes of data:
Reply from 192.168.1.69: bytes=32 time<1ms TTL=128
Reply from 192.168.1.69: bytes=32 time<1ms TTL=128
Reply from 192.168.1.69: bytes=32 time=1ms TTL=128
Reply from 192.168.1.69: bytes=32 time=1ms TTL=128

Ping statistics for 192.168.1.69:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 1ms, Average = 0ms

[eliassal]

Can you please tell me what versions of sql server are compatible (2019, 2016, 2014.........)., Mine is
Microsoft SQL Server 2016 (SP2-CU15)

[victor]

Hi!

Do you have SQL Server Native Client installed?

Best regards,
Victor

[eliassal]

No Sir, it is not indicated in the prerequisites. I thought the setup takes care of everhthing

[eliassal]

Correct Victor, and thanks I downloaded and installed SQL native client and setup went through without issue. But when I clicked on "Finish", nothing happened, no message....no wizard again and not sure how to continue

[eliassal]

I installed teh web-ui and was able to login, updated network configuration to do "Passive...". First of all, I have a 2 or 3 machines who have 2 or 3 NIcs, in the "entire network" list, those machines are repeated as the same number of Nics.
2nd, under all discovered machines, there is Nic icon flagged with "Unknown".
Also, I have a D-Link switch which was not discovered.

So my last query is about "Network Monitoring" for which I was interested to test NetXMS. Can you please let me know where I can monitor network traffic?

Thanks

[Filipp Sudanov]

You need either SNMP daemon or netxms agent installed on the machines that have several NICs - then netxms will understand that all NICs belong to one machine. This will also solve Unknown network interface issue.

Once you have a node that is accessible via SNMP or netxms agent you can right-click on interface and select "Create data collection items". There you will be able to create the data collection items (DCIs) that will collect numeric data on the traffic. Then you can right-click node and select Last values - the data will be there.