Sunday 9 February 2014

Mendix and SQL Server: Initializing the ConnectionBus failed

After installing Mendix and SQL Server it happens most of the time that running a mendix application the following message appears:
Message: Initializing the ConnectionBus failed.
Cause: Error on initializing database connection.
Stack trace: com.mendix.m2ee.api.AdminException: Initializing the ConnectionBus failed.
at com.mendix.core.MxRuntime.H(SourceFile:472)
Caused by: n: Error on initializing database connection.
at bz.b(SourceFile:218)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

You need to start "SQL Server Configuration Manager"
Go to Start --> Microsoft SQL Server --> Configuration Tools --> SQL Server Configuration Manager

When it opens go to "SQL Server Configuration Manager" --> "SQL Server Network Configuration" --> "Protocols for SQLExpress".

  1. Where you'll find the Protocol TCP/IP, if disabled then Enable it.
  2. Double click on TCP/IP, You'll find its properties and select the "IP Address" tab. In this tab Remove All the TCP Dynamic Ports and add value 1433 to all TCP Port
  3. Restart your SQL Server via "SQL Server Services" --> "SQL Server" --> Restart

Change TCP/IP Disabled to Enabled

Set TCP Dynamic Ports to 0 and TCP Port to 1433

After this, the Mendix application can be started.

No comments:

Post a Comment