SQL Server Connector

[omar-awwad]

I’m trying the latest Camunda version 8.6 on local docker images,
[camunda-platform/docker-compose/camunda-8.6 at main · camunda/camunda-platform · GitHub]
with latest desktop modeler 5.28 .

I’m trying a zebee c# client to deploy and run sample model that connects to local SQL server DB , using sql connector.

I filled all the required probertites for SQL connector , as below :

But get this error :

Cannot create the Database connection: The TCP/IP connection to the host OMARLAP, port 1433 has failed. Error: “OMARLAP. 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.”.

Knowing that I can access the SQL Server instance on my local machine with same credentials without any issue , also I configured the instance to accept TCP/IP connections from SQL Server configuration manager.

what might be the the issue ?

[hassang]

You are connecting from inside the Camunda container to a database running on the host machine so try using the actual IP address of your machine as Host.

On Windows:
ipconfig

On Linux/macOS:
ifconfig

-Make sure TCP/IP is set to listen on all IPs, including 0.0.0.0, or at least the IP Docker containers can access.
-Ensure “Allow remote connections to this server” is checked.

Server configuration: remote access - SQL Server

[omar-awwad]

Thank you @hassang for your help ,

I used the IP address of my machine (as I’m connected to internet ) , and things worked ok for me.

Thanks very much for continuous support.