Share via

Data Factory SQL Server Connection Error

  • Article

Question

Wednesday, December 18, 2019 4:57 AM

Hello,

I am trying to use Azure's data factory to copy data from a SQL Server. I am able to access this server using SQL server management studios but when I try to access using Azure data factory I receive the following error.

Cannot connect to SQL database: 'servername', Database: 'databasename', User: 'userid'. Please check the linked service configuration is correct, and make sure the SQL database firewall allows the integration runtime to access. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server),SqlErrorNumber=53,Class=20,State=0, The network path was not found Activity.

I am relatively new to Azure and any help would truly be appreciated.

Thank you.

All replies (3)

Wednesday, December 18, 2019 6:31 AM

Hi SantiASC,

According to your error message, this error usually means that the SQL Server computer can't be found or that the TCP port number is either not known, or is not the correct port number, or is blocked by a firewall.

 

There is a professional document about Troubleshoot Connecting to the SQL Server Database Engine, and you can refer it: /en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017

 

The possible reasons are described below:

1) MSSQL Server is not started.

2) Firewall is blocking port 1433.

3) TCP/IP protocol is disabled for MSSQL protocols.

4) Make sure your database engine is configured to accept remote connections.

5) If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings.

6) Make sure your login account has access permission on the database you used during login.

 

For more details, you can refer to this article : http://support.sysonline.com/support/solutions/articles/4000016491-errmsg-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql

 

Hope it can help you .

 

Best Regards,

Rachel

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

Wednesday, December 18, 2019 6:46 AM

Hello,

I am trying to use Azure's data factory to copy data from a SQL Server. I am able to access this server using SQL server management studios but when I try to access using Azure data factory I receive the following error.

Is it an Azure SQL or on-premise SQL server. Please note that, to connect on-prem servers, you will have to run Integration runtime setup in the machine where SQL is installed to bring the SQL server in Azure cloud. 

Connect to On-premises Data in Azure Data Factory with the Self-hosted Integration Runtime - Part 1

If the response helped, do "Mark as answer" and upvote it

  • Vaibhav

Friday, December 20, 2019 7:37 AM

Hi ,

 

I am writing to follow up this thread with you. Have you solved your issue? If you have solved your issue ,in order to close this thread, please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated.

 

Best Regards,

Rachel

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.