Copy data from on-Premise sql server to azure data to azure data lake soure connection issues

Question

I've got an Azure Data Factory pipeline that copies data from an on-prem SQL Server to data lake
when i checked source test connection following issue came
Cannot connect to SQL Database: '------', Database: '-----', User: '-----'.
Check the linked service configuration is correct,
and make sure the SQL Database firewall allows the integration runtime to access.
Cannot open database "*******" requested by the login. The login failed. Login failed for user '*****'., SqlErrorNumber=4060,Class=11,State=1, Activity ID: a10e5f3a-e86e-41ae-8eaf-f273544ffd02

Answer 1

Hi @Maremutt siva ,

Did you failed in below step?

In the New Linked Service (SQL Server) dialog box, confirm that testIntegrationRuntime is selected for the Integration Runtime field. Then, take the following steps:

a. Under Name, enter SqlServerLinkedService.

b. Under Server name, enter the name of your SQL Server instance.

c. Under Database name, enter the name of your on-premises database.

d. Under Authentication type, select appropriate authentication.

e. Under User name, enter the name of user with access to SQL Server.

f. Enter the password for the user.

g. Test connection and select Finish.

Please check your steps from below blogs find if you missed some steps.

Copy data from a SQL Server database to Azure Blob storage by using the Copy Data tool
Move Data from On-Premise SQL Server to Azure Blob Storage Using Azure Data Factory

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it.