Forum Discussion

Jalalmn's avatar
Jalalmn
Frequent Visitor
2 years ago
Solved

error on MSSQL database import with dataflow gen2

Hi,

 

I have received a SQL Server connection using username and password (and server) and want to use it in fabric dataflow gen2.

The connection works on azure data studio and even power BI desktop. But on dataflow gen2, it returns an error:

 

The connection could not be established. Access may not be possible via this network or via this URI, or a gateway may be required to access this data source.

 

I have played with different server with port and without port settings, but it does not work.

 

Would appreciate your help!

Best,

Jalal

Dataflows
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Jalalmn ,

    As I said above, SQL Server is an on-premises data source that requires a gateway to upload to Fabric Data Factory.

    If you select SQL Server instead of gateway, the above error will occur.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jalalmn ,

    I also create a SQL Server as you mentioned.

    Then I select SQL Server database in Data flow Gen2.

    When I choose not to use the gateway connection during the connection process, the same warning will be returned as you.

    So I think you should choose the gateway correctly and make sure that the gateway is configured correctly.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Jalalmn's avatar
      Jalalmn
      Frequent Visitor
      2 years ago

      Thank you so much for your quick reply ğŸ™‚

       

      You mean regarding the context there is no way to make the connection work directly (without gateway)?

       

      Best,

      Jalal

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Jalalmn ,

        As I said above, SQL Server is an on-premises data source that requires a gateway to upload to Fabric Data Factory.

        If you select SQL Server instead of gateway, the above error will occur.

         

         

        Best Regards

        Yilong Zhou

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.