Question 105828 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – Pipeline for stored procedure dedicated sql pool

I am trying to create a pipeline for my stored procedure in dedicated SQL pool. I am getting error Cannot connect to SQL database "" Check the linked service config is correct, and make sure the SQL database firewall allows the integration runtime to access. Logon failed for user ""

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    This was due to access issue. Admin granted relevant access and now it's working.


  2. 0

    Check if the provided user details are correct and the linked service is successfully connected. Add the client IP address in the synapse workspace network to allow access to the client network.

    enter image description here

    You can call store procedure in your pipeline using stored procedure activity, lookup activity, copy data activity.

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search