ADF Copy Data from on-premises SQL server to Azure SQL server

Manoj Kumar 20 Reputation points
2024-06-13T06:50:30.07+00:00

Error details

local_sql_db_2_azure_sql_db

Error code SqlFailedToConnect

Failure typeUser configuration issue

DetailsErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '', Database: 'db', User: 'admin'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Login failed for user 'admin'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=18456,Class=14,ErrorCode=-2146232060,State=1,Errors=[{Class=14,Number=18456,State=1,Message=Login failed for user 'admin'.,},],' Activity ID45f7cb05-ccbe-41ba-a0bd-bf27a8e581bb

Added Firewall rule too

User's image User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,353 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,187 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 31,511 Reputation points MVP
    2024-06-13T11:08:03.1333333+00:00

    Based on your question, your source seems to be an onpremises database.

    So you must be using a self hosted IR.

    Can you confirm whether you are able to access the Azure SQL database from the server on which the SHIR is hosted?

    Because whenever a SHIR is being used either in source or sink of a copy activity, the SHIR acts as a bridge between the source and the sink; so both the source and the sink must be accessible from within the server hosting the SHIR for the copy activity to be a success


0 additional answers

Sort by: Most helpful