Forum Discussion

Steefff's avatar
Steefff
Frequent Visitor
6 months ago
Solved

Copy JOb to write data from Fabric Warehouse to SQL Server On Premise

Dear all i'm trying to create a Copy Job to read data from Fabric Warehouse and write to a SQL Server on premise. Th copy JOB fails with this error message: "Cannot connect to SQL Database. Please c...
data warehouse
  • Steefff's avatar
    Steefff
    6 months ago

    We have resolved!

    The problem is the comunication in outboud between gateway and fabric on port 1433 (443 for file is open and this is way the write from lakehouse to sql on prem works).

    Since the reading of data from Fabric happens on the gateway, and not in Fabric itself as I thought, I was having a connectivity problem because the gateway could not reach Fabric. The system administrators fixed the network rules and now everything works.

    Thanks to everyone

Steefff's avatar
Steefff
Frequent Visitor
6 months ago

We have resolved!

The problem is the comunication in outboud between gateway and fabric on port 1433 (443 for file is open and this is way the write from lakehouse to sql on prem works).

Since the reading of data from Fabric happens on the gateway, and not in Fabric itself as I thought, I was having a connectivity problem because the gateway could not reach Fabric. The system administrators fixed the network rules and now everything works.

Thanks to everyone