Forum Discussion

dfkelso's avatar
dfkelso
New Member
3 years ago

Lakehouse Gen2 Datasource - Azure SQL DB cannot connect

I am using the Azure SQL Connector, but when I try with the Gen2 Dataflow I get the following error: "Connection could not be created. This may mean it is not accessible from this network or at this ...
Dataflows
dfkelso's avatar
dfkelso
New Member
3 years ago

i havent officially gotten a full resolution. i HAVE gotten past this error by making it connect through a gateway, but once i get past that the data does not ever publish. just throws a different, somehow more vague, error. i am working through these errors with msft support and will report back when i (hopefully) get it resolved. 
in troubleshooting, i was able to set up a pipeline on the same sql database without the gateway that populated a table in the lakehouse ... so i am not really sure why or what the difference is.

unfortunately i dont control the azure sql server and cannot connect to the master db nor the azure sql tenant where this is hosted because it is a vendor hosted db that i have read-only rights to.  

HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
3 years ago

Thanks dfkelso  for the quick reply .
As a understand at this time the pipeline works for the  ASQL but not the DF gen2 . 
May I request you please post the resolution , so that its helpful to other community member . If you have the SR# , please do share the same here .

Thanks

Himanshu