unbale to fetch the onprem stored procedure in ADF pipeline

Question

unbale to fetch the onprem stored procedure in ADF pipeline

Anonymous

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,

Anonymous

2023-05-01T10:01:05.1+00:00

I am getting the above error while fetching the stored procedure from on-prem DB. to do that we created linked server and doing it. That time i am facing this error.
AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-05-02T06:00:34+00:00

Hi Bommisetty, Rakesh (Hudson IT Consultant) ,

Did you get a chance to visit the resolution provided in the above shared link by Samy Abdul . It contains the troubleshooting steps which might be of your help. Please check and let us know if it was helpful. Thankyou.
AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-05-11T06:29:10.7533333+00:00

Hi Bommisetty, Rakesh (Hudson IT Consultant) ,

Any updates on the issue resolution?

2 answers

Your answer

Anonymous

2023-05-01T10:01:05.1+00:00

I am getting the above error while fetching the stored procedure from on-prem DB. to do that we created linked server and doing it. That time i am facing this error.
AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-05-02T06:00:34+00:00

Hi Bommisetty, Rakesh (Hudson IT Consultant) ,

Did you get a chance to visit the resolution provided in the above shared link by Samy Abdul . It contains the troubleshooting steps which might be of your help. Please check and let us know if it was helpful. Thankyou.
AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-05-11T06:29:10.7533333+00:00

Hi Bommisetty, Rakesh (Hudson IT Consultant) ,

Any updates on the issue resolution?

Answer 1

Vinodh247 42,531 MVP Volunteer Moderator

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?

Check the login has permission to access and run the SP
Test the linked service connection if its working
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

Answer 2

Samy Abdul 3,376

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

AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-05-15T04:55:55.0933333+00:00

Hi Bommisetty, Rakesh (Hudson IT Consultant) ,

Just following up to see if the above answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

Share via

unbale to fetch the onprem stored procedure in ADF pipeline

2 answers

Your answer