Forum Discussion
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...
We have created private endpoint. But it works for notebook in Fabric. But it does not work for datapipeline in Fabric.
Houston-hoAdvocate I
I believe you are using different authentication method to your SQL server. Are they the same in both notelook and pipeline linked service?
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
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".