Hi, I downloaded netxms-server-3.9.298-x64 on a win 10 64 machine, I chose MS SQL server, I enter correct information for the DB server (which is a named or default instance), correct logins or * but always getting an error
NetXMS Database Manager Version 3.9.298 Build 3.9-298-g2adbdd51e5 (UNICODE)
Unable to connect to database server SQL2K12\SC2K12 as sa ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)
***** PRESS ANY KEY TO CONTINUE *****
or when using * as my login has all privileges on the DB server, get same thing
Whatever I choose I get "Data source name not found and no default driver specified"
Thanks for your help
Do you actually have MS SQL database installed?
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
QuoteUnable 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
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
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
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.
Hi Filipp, I already tried with another sql server default installation, not a named instance (without the /), same issue happened
Filipp, I have just tried all possibilities with the command, default instance DB host name , IP, named instance ip/named instance
Quotenxdbmgr check
I get the same exact error as you can notice for the 4 tests
QuoteNetXMS 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)
QuoteC:\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)
QuoteC:\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)
QuoteC:\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
QuotePinging 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
Can you please tell me what versions of sql server are compatible (2019, 2016, 2014.........)., Mine is
Microsoft SQL Server 2016 (SP2-CU15)
Hi!
Do you have SQL Server Native Client installed?
Best regards,
Victor
No Sir, it is not indicated in the prerequisites. I thought the setup takes care of everhthing
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
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
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.