Starting Camunda Tomcat with manually created database (mssql)

Camunda 7 Topics Discussion & Questions
1

Hi guys. I have a problem with running the Tomcat server. I created a database in Microsoft SQL server management studio.
The error message looks like this: The TCP/IP connection to the host 127.0.0.1, 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.".

server.xml looks like this:

<Resource name="jdbc/ProcessEngine"
          auth="Container"
          type="javax.sql.DataSource" 
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          uniqueResourceName="Camunda"
          driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
          url="jdbc:sqlserver://localhost:1433/Camunda"
          defaultTransactionIsolation="READ_COMMITTED"
          username="sa"  
          password=".v>>4T^[#f/B)9Qx"
          maxTotal="20"
          minIdle="5"
          maxIdle="20" />

Value of uniqueResourceName is database name (Camunda). Also I specified databaseSchemaUpdate to false, added BMP Bootstrap Server Listener and enabled TCP/IP port with value of 1433.
For example, I can connect to the database via SSMS:

2

Did you also add the correct SQL server driver?

1 Like
3

The problem was with sqljdbc41.jar file (I think). Now it works!

1 Like
4