Unable to connect to Database - Windows MSSQL

[krknopp]

I'm trying to install a new NetXMS server.  I've installed MSSQL Express Edition on localhost and verified Windows Authentication works via the management console.  When i run the NetXMS installation it can't connect to the database.  I've entered * for the user, no password and entered the administrator account for the service to run as.  I even tried creating a database and telling the install file to use an existing database, but I get the same results.

I'm running Windows Server 2003 Standard Edition, SP2 and Microsoft SQL Server 2005 Express Edition SP2.

Thanks for the help.

Kerry

[victor]

Hello!

Do you have TCP/IP enabled on SQL server? NetXMS can use only TCP/IP connection.

Best regards,
Victor

[krknopp]

the SQL server is on the local box so there's no changes there is no TCP connection.  I did enable all remote connections to see if it made a difference, but it didn't.  Still cannot connect to it.

[victor]

I'll try to setup Microsoft SQL Server 2005 Express Edition to chek it myself. Please wait till Monday's evening.

Best regards,
Victor

[krknopp]

any luck on this?

[krknopp]

I would really like to try this software out.  I'd rather run it on Windows, but I guess I'll try Linux and see what happens.  Please test it when you get time and let me know your findings.

[victor]

Hello!

Sorry for delay with reply, was really busy last weeks... Just download SQL 2005 Express, will check it this weekend.

Best regards,
Victor

[victor]

Just check it on my laptop (the only difference is that it's Windows Vista not Windows Server 2003). It's not working out of the box, but start to work when I enable TCP/IP in SQL Server Configuration Manager (see attached screenshot). Do you have the same settings? Also, when installing, did you select "Microsoft SQL DB-library" component?

Best regards,
Victor

---

[victor]

P.S. You can also try to setup ODBC and use odbc.ddr instead of mssql.ddr.

Best regards,
Victor

[krknopp]

thanks for the help.  I actually need to change the default database name from localhost to .\sqlexpress and it connected right up.

Kerry