Unable to connect to Database - Windows MSSQL

Started by krknopp, October 30, 2007, 02:40:18 PM

Previous topic - Next topic

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 Kirhenshtein

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 Kirhenshtein

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

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 Kirhenshtein

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 Kirhenshtein

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 Kirhenshtein

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