I'm using mssql.ddr as driver.
And I configured the "sa" user with a working password, at least it's working with the MS SQL Studio, within the netxmsd.conf.
If I try to start netxmsd -D6 or try to initialise the db with nxdbmgr init <pathtoscript>\dbinit_mssql.sql I get the following error:
QuoteNetXMS Database Manager Version 2.0-M2 Build 8009
Unable to connect to database netxms@4c-monitor as sa: [Microsoft][SQL Server Na
tive Client 10.0][SQL Server]Fehler bei der Anmeldung f³r den Benutzer 'sa'.
Can someone help me to find a solution to this problem?
Show us the netxmsd.conf please (feel free to remove sensitive info).
This is the latest configured netxmsd.conf.
Thank you for checking it up.
Quote
#
# NetXMS Server configuration file
# Created by NetXMS Server configuration wizard at Sun Oct 12 23:02:38 2014
#
#LogFile = {syslog}
LogFile = C:\netXMS\log\netxmsd.log
DebugLevel = 6
DBDriver = mssql.ddr
DBServer = 4c-monitor
DBName = netxms
DBLogin = sa
DBPasswort = XxxxxxxxxD
#DBLogin = 4cgroup\4cs
#DBPasswort = 4xxxxxxxx6
LogFailedSQLQueries = yes
#JavaPath=C:\NetXMS\bin\jre
#JavaLibraryDirectory=C:\NetXMS\lib
#JDBCDriver=C:\NetXMS\sqlite-jdbc-3.8.7.jar
#JDBCUrl=jdbc:sqlite:C:/netxms/database/netxms_db
First thing I would try is specify the DB server address as a FQDN.
Let us know if that helped.
I see a typo in your config: DBPasswort - should be DBPassword.
Best regards,
Victor
Thank you both.
It is working now.
I guess the typo was preventing the initialisation.
Sometimes solutions to a problem can be so simple ;-)
Thank you once again.