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

Maremutt siva 1 Reputation point
2020-11-29T01:13:16.153+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,644 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2020-11-30T03:18:09.19+00:00

    Hi @Maremutt siva ,

    Did you failed in below step?
    43428-screenshot-2020-11-30-111203.jpg

    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.

    0 comments No comments