unbale to fetch the onprem stored procedure in ADF pipeline

Question

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,

Answer 1

Hi, please go through below thread, it might help ;

https://learn.microsoft.com/en-us/answers/questions/336067/azure-data-factory-azure-sql-connectivity-error-ch

https://www.sqlshack.com/executing-stored-procedures-from-data-pipelines-in-azure-data-factory/ Thanks

Answer 2

Hi

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.