Forum Discussion
Copy JOb to write data from Fabric Warehouse to SQL Server On Premise
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
Hi deborshi_nag
thanks for you response.
i try some other scenario.
Read from the warehouse and write to SQL Server 2017 on Premise --> FAILS
Read from the lakehouse and write to SQL Server 2017 on Premise --> WORKS
Read from the warehouse and write to lakehouse --> WORKS
i have try with simple table with one single column, int type. but it still fails.
it seems there a problem when the data from the warehouse go out of fabric, to the SQL server ON premise.
It could be a problem of the SQl Server on prem version? it' a SQL server 2017 Developer edition
Thanks
Stefania
Super Userhey Steefff on your Data Gateway can you check if connectivity to your on-prem SQL database works?
Run this on a PowerShell prompt:
Test-NetConnection your-sql-server-name -Port 1433
If you get "TcpTestSucceeded : True" it confirms there's no problem with connectivity.