SQL Server connection issue in Action flow.

My bet is that the server name can't be resolved into an IP by the Celonis EMS.... try using the IP instead of the server name

Hi,

Good lead @Guillermo Gost, also if your host name is DESKTOP_XXXXXX I can assume it's just local machine with Windows 10/11. In that case I can also assume that you're using Microsoft SQL Server Express, which will be installed locally. If so, you cannot reach to it from the web without exposing your computer (not adviced - better to rent server and host it there).

For accessing locally hosted MS SQL instance you will need:

A) Public IP (needed to send requests to your home/work router)

B) Port forwarding set up in your router (request sent to router needs to be redirect to specific open port in your computer with SQL server installed)

C) Adjusting windows firewall to accept that specific requests to your SQL server data base from the router.

D) Set sql server authentication in sql server (windows authentication wont work) and allow for remote connections

General IT security TIP: if you're ever doing port forwarding - it's good to doing that with someone that has some net infrastructure knowledge. It's because missconfiguration here can lead to exposing the network. Also, always set that forwarded port to not generally used (TCP 1433, 4022, 135, 1434, UDP 1434.) but rather bigger then 6000+ (less scanned by hackers and scripts).

To read:

Public IP: https://www.avast.com/c-ip-address-public-vs-private

Port forwarding (router): https://www.noip.com/support/knowledgebase/general-port-forwarding-guide/

Firewall exception (Local windows machine): https://www.tomshardware.com/news/how-to-open-firewall-ports-in-windows-10,36451.html

General SQL server topic: https://stackoverflow.com/questions/28060789/is-there-anyway-to-connect-to-local-sql-server-database-from-hosted-website

Security for port forwarding: https://serverfault.com/questions/65321/what-ports-are-least-likely-to-be-probed-on-the-internet

@1460034228 However I'm not sure if that will help you because we're lacking the details about your database setup. If that a company/client database, you can describe the setup generaly and/or provide some refurbished screenshots without company name etc.

Best Regards,

Mateusz Dudek

Hi,

Good lead @Guillermo Gost, also if your host name is DESKTOP_XXXXXX I can assume it's just local machine with Windows 10/11. In that case I can also assume that you're using Microsoft SQL Server Express, which will be installed locally. If so, you cannot reach to it from the web without exposing your computer (not adviced - better to rent server and host it there).

For accessing locally hosted MS SQL instance you will need:

A) Public IP (needed to send requests to your home/work router)

B) Port forwarding set up in your router (request sent to router needs to be redirect to specific open port in your computer with SQL server installed)

C) Adjusting windows firewall to accept that specific requests to your SQL server data base from the router.

D) Set sql server authentication in sql server (windows authentication wont work) and allow for remote connections

General IT security TIP: if you're ever doing port forwarding - it's good to doing that with someone that has some net infrastructure knowledge. It's because missconfiguration here can lead to exposing the network. Also, always set that forwarded port to not generally used (TCP 1433, 4022, 135, 1434, UDP 1434.) but rather bigger then 6000+ (less scanned by hackers and scripts).

To read:

Public IP: https://www.avast.com/c-ip-address-public-vs-private

Port forwarding (router): https://www.noip.com/support/knowledgebase/general-port-forwarding-guide/

Firewall exception (Local windows machine): https://www.tomshardware.com/news/how-to-open-firewall-ports-in-windows-10,36451.html

General SQL server topic: https://stackoverflow.com/questions/28060789/is-there-anyway-to-connect-to-local-sql-server-database-from-hosted-website

Security for port forwarding: https://serverfault.com/questions/65321/what-ports-are-least-likely-to-be-probed-on-the-internet

@1460034228 However I'm not sure if that will help you because we're lacking the details about your database setup. If that a company/client database, you can describe the setup generaly and/or provide some refurbished screenshots without company name etc.

Best Regards,

Mateusz Dudek

Hi,

Good lead @Guillermo Gost, also if your host name is DESKTOP_XXXXXX I can assume it's just local machine with Windows 10/11. In that case I can also assume that you're using Microsoft SQL Server Express, which will be installed locally. If so, you cannot reach to it from the web without exposing your computer (not adviced - better to rent server and host it there).

For accessing locally hosted MS SQL instance you will need:

A) Public IP (needed to send requests to your home/work router)

B) Port forwarding set up in your router (request sent to router needs to be redirect to specific open port in your computer with SQL server installed)

C) Adjusting windows firewall to accept that specific requests to your SQL server data base from the router.

D) Set sql server authentication in sql server (windows authentication wont work) and allow for remote connections

General IT security TIP: if you're ever doing port forwarding - it's good to doing that with someone that has some net infrastructure knowledge. It's because missconfiguration here can lead to exposing the network. Also, always set that forwarded port to not generally used (TCP 1433, 4022, 135, 1434, UDP 1434.) but rather bigger then 6000+ (less scanned by hackers and scripts).

To read:

Public IP: https://www.avast.com/c-ip-address-public-vs-private

Port forwarding (router): https://www.noip.com/support/knowledgebase/general-port-forwarding-guide/

Firewall exception (Local windows machine): https://www.tomshardware.com/news/how-to-open-firewall-ports-in-windows-10,36451.html

General SQL server topic: https://stackoverflow.com/questions/28060789/is-there-anyway-to-connect-to-local-sql-server-database-from-hosted-website

Security for port forwarding: https://serverfault.com/questions/65321/what-ports-are-least-likely-to-be-probed-on-the-internet

@1460034228 However I'm not sure if that will help you because we're lacking the details about your database setup. If that a company/client database, you can describe the setup generaly and/or provide some refurbished screenshots without company name etc.

Best Regards,

Mateusz Dudek