Forum Discussion

Winnie20242024's avatar
Winnie20242024
New Member
2 years ago

How to link SQL server in private network from pipeline in Fabric?

Hello e , Do you have any idea about linking SQL server in private network from pipeline in Fabric?   We have created: 1)SQL server in private network in Azure 2)managed private endpoint in Fabri...
pipelines
Houston-ho's avatar
Houston-ho
Icon for Advocate I rankAdvocate I
2 years ago

I believe you are using different authentication method to your SQL server. Are they the same in both notelook and pipeline linked service?

Winnie20242024's avatar
Winnie20242024
New Member
2 years ago

In Notebook, we are using jdbc with user name and password to connect SQL server

 

In Pipeline, we are trying to use  the "Basic" auth kind with username and passsword like below:

 

Any suggestion? Thanks

  • Houston-ho's avatar
    Houston-ho
    Icon for Advocate I rankAdvocate I
    2 years ago

    Have tried using other authentication method like AAD or Service Principal?

    And have you enable this setting?

    Allow Azure services and resources to access this server" is set to "Yes".

     

    • Winnie20242024's avatar
      Winnie20242024
      New Member
      2 years ago

      Currently we are limited to chose

      • username/password or
      • Service Principal

      only one above but not both.

       

      And we choose username/password for SQL server. 

       

      For the networking settings, our public access is also disabled.