Forum Discussion
How to link SQL server in private network from pipeline in Fabric?
We have created private endpoint. But it works for notebook in Fabric. But it does not work for datapipeline in Fabric.
Advocate II 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".
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.