MSSQL Database connectivity problem

Started by crusader, March 21, 2015, 06:10:16 PM

Previous topic - Next topic

crusader

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?

tomaskir

Show us the netxmsd.conf please (feel free to remove sensitive info).

crusader

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

tomaskir

First thing I would try is specify the DB server address as a FQDN.

Let us know if that helped.

Victor Kirhenshtein

I see a typo in your config: DBPasswort - should be DBPassword.

Best regards,
Victor

crusader

#5
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.