Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago
Solved

Save onprem SQL Server data into Lakehouse through Dataflow Gen2

I have the gateway installed on the machine with the SQL Server running that is not open to the internet. I have created a Dataflow Gen2 to access the data and I can see the data through Dataflow pre...
Dataflows
General Question
Need Help
  • amaaiia's avatar
    amaaiia
    2 years ago

    There is not a solution. We've had 5 extended calls with Microsoft support to solve this but they don't know why is this happening to us. Finally, we are working with new internal users created in main tenant (not guest users).

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago

I have checked both.
1. There is access between the lakehouse and the SQL Server machine:


2. The gateway version is recent, from december 2023. Version 3000.202.16 (December 2023)

 

I still get the same error.

pqian_MSFT's avatar
pqian_MSFT
Microsoft Employee
2 years ago

amaaiia can you share the session ID here (it is PII-free), that way we can at least see what is the error message.

We may also need additional logs from your GW machine to diagnose it further.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi amaaiia 


    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
    Otherwise, will respond back with the more details and we will try to help.


    Thanks.