Setup not going through with SQL Server
-
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 thingWhatever 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
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
-
-
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.
-
-
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=128Ping 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 -
-
Hi!
Do you have SQL Server Native Client installed?
Best regards,
Victor -
-
-
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login