Modern App SQL Server Connection Fails - Need Help Establishing Connection from UiPath Apps

Help Apps
1

Hi everyone,

I’m building a solution where UiPath Modern Apps needs to connect to a SQL Server database.
When I use the **Database Connection ** action inside Modern Apps, I receive errors and the connection never succeeds.

image
image310×169 18.6 KB

I also build a cross-platform solution. An isolate solution which task is only to establishing connection with SQL. It ran perfectly in Studio Desktop, but when I am using on Cloud I get the same error.

SQL Server is hosted on a dedicated Windows server inside our network.

The goal is, from Modern Apps, I want to export data from Data Fabric to SQL.

Is there a way to configure in UiPath that I overlooked or is there any other alternative solution to this?

Thank you

2

hii @stuN

Your SQL connection works in Studio because it runs inside your networkbut Modern Apps and Cloud jobs run outside your network so they cannot reach your onprem SQL Server.

To fix this, you need a secure bridge such as UiPath Data Gateway or an onprem unattended robot that performs the SQL actions from inside your network.

This is the recommended way to let Modern Apps send data to SQL.

1 Like
3

Hi

You can try this approacH Use an On-Premise Robot And Run the SQL workflow on a machine inside your network then use Modern Apps → triggers process → robot updates SQL

Use UiPath Integration Service Gateway

Official cloud → on-prem connector Install gateway → add SQL connection → use it in Apps/cloud projects.

Create your own API layer Modern Apps calls an API → API updates SQL.

Cheers

1 Like
4

@stuN

Welcome to the community

as per the error and as per description that you provided

as server is on prem ..from studio desktop which again is in same mnetwork might not create issue

but your apps would run on a cloud instance so you might need to configure SQL server to receive remote connections. which again is mentioned in the error

Hope this helps

cheers

1 Like
5

Modern Apps, Cross-platform jobs, and Cloud Robots run in UiPath Cloud.
Your SQL Server is on-prem inside your private network.

Because of this, the Cloud cannot resolve or reach the SQL Server
(hostname is not known → error 35).

To solve this, you must create a network bridge using either:
• UiPath Hybrid Connector (recommended)
• UiPath SQL Integration Service connector
• Or run the database workflow using an on-prem Robot

Direct DB connection from cloud to internal network is not possible
without hybrid connectivity.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.