Forum Discussion

Amit0167's avatar
Amit0167
New Member
2 years ago
Solved

Reading and Writing data from Synapse to Fabric Warehouse

Hi,

 

I have an existing pipeline in ADF that populated my Raw layer data in ADLS2 and then SilverLayer Data in Synapse Dedicated Pool. I want to create a new task in same pipeline to populate a table in Fabric Warehouse.

 

I have created a Service Principle for Fabric and i tried creating a liniked service in ADF but i am getting an error

 

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxxxxxxxxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com', Database: 'xxxxxxxxxxxxxxxxxxxxx', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Login failed due to invalid authentication methods., SqlErrorNumber=18456,Class=14,State=1,

 

I tried this link but for the inbound Network Security, i am lost somewhere Set up and use private links for secure access to Fabric (Preview) - Microsoft Fabric | Microsoft Learn

 

any help is appreciated.

data engineering

4 Replies

  • AmitGarg's avatar
    AmitGarg
    Frequent Visitor
    2 years ago

    I have got the solution to my porblem now....

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

      Hi AmitGarg 

       

      Glad that you were able to find some insights and appreciate if you could share the same with the community as it can be helpful to others.
      Please continue using Fabric Community for further queries.

       

      Thanks.

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

    Hi Amit0167 

     

    Thanks for using Microsoft Fabric Community.

    Apologies for the inconvenience.

    It would be helpful if you could you please share screenshots of any error messages you've encountered, along with your current pipeline configuration. This additional information will help me to understand and guide you in better way.

     

    Thank you.