unbale to fetch the onprem stored procedure in ADF pipeline


while I am fetching the stored procedure i am getting below error in the ADF pipeline.

Error :

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DBDEV-01', Database: '2_dev', User: 'YRE\Dev'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Cannot open database "2_dev" requested by the login. The login failed. Login failed for user 'YRE\Dev'., SqlErrorNumber=4060,Class=11,State=1,

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,453 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Samy Abdul 3,361 Reputation points

  2. Vinodh247 7,416 Reputation points


    Thanks for reaching out to Microsoft Q&A.

    Did you try connecting the database from SSMS using login 'YRE\Dev'? did it throw the same error?

    1. Check the login has permission to access and run the SP
    2. Test the linked service connection if its working
    3. Check If the firewall is open to let the linked service access the database.

    Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

    0 comments No comments