NetXMS Forum

I was able to get around this by creating a blank database using SQL Server Management Studio and then choosing "Use existing database" along with checking the "Initialize database" checkbox.  It seems like the DBA User = * option is not working with my setup.

I am getting an error connecting to the database on the "applying server configuration" step.

Windows Server 2012 Standard
Microsoft SQL Server Express 2012 x64

• SQL Server is installed as the default instance (MSSQLSERVER).
• I checked that Named Pipes and TCP/IP are both enabled protocols for SQL.
• I verified that MyDomain\MyAccount is server admin on this SQL instance.  Also to verify, I connected as this user (using SQL server management studio) and created a test database.
• The NetXMS core service is setup to run as MyDomain\MyAccount
• I verified that SQL is allowed on the firewall

On the select database page I have this selected:

• Microsoft SQL Server
• mssql.ddr
• localhost
• create new database
• DBA login name = *
• DBA password =
• Database name = netxms_db
• DB login name = *
• DB password =

The error message I get is "Unable to connect to database [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'MyDomain\MyAccount'."

If I change the database server from "localhost" to "MyServerNetBIOSName" I get the same message.
If I change the database server from "localhost" to "MyServerNetBIOSName\MSSQLSERVER" I get "Unable to connect to database [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Connection string is not valid [87].", but I get a similar message if I try to connect to this instance in SQL management studio. 

Any suggestions about what I am doing wrong?

Thanks