Forum Discussion
Copy data from on-premise database to Fabric SQL database
It sounds like an issue with the linked service configuration. Have you checked if 'FabricSqlDatabase' is a supported type in your data pipeline setup? Also, ensure that all required permissions are granted to the service principal. Sometimes, revalidating the connection and updating the linked service type can resolve the issue. Hope this helps!
nilendraFabric , Did not work? Got another error
ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: . Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.),Source=.Net SqlClient Data Provider,SqlErrorNumber=121,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=121,State=0,Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.),},],''Type=System.ComponentModel.Win32Exception,Message=The semaphore timeout period has expired,Source=,'
Hi Hemant_Patel ,
Thanks for reaching out to the Microsoft Fabric Community forum.
The error message you're encountering indicates that there is a problem with connecting to your SQL Database. Here are some steps you can take to troubleshoot and resolve the issue:
- Ensure that the connection string used in your application or Data Factory is correct. Verify the server name, database name, username, and password.
- Make sure that the SQL Database firewall settings allow access from the IP address of the Data Factory runtime. You can check this in the Azure portal under the SQL Database settings.
- Ensure that the SQL Server is configured to allow remote connections. You can check this in the SQL Server Management Studio (SSMS) under server properties.
- If the connection is timing out, consider increasing the timeout settings in your connection string.Implement retry logic in your application to handle transient errors, as sometimes the issue may be temporary.
Additonally you can refer this doc related to Troubleshoot connectivity issues in SQL Server :
A network-related or instance-specific error occurred - SQL Server | Microsoft Learn
Troubleshoot connectivity issues in SQL Server - SQL Server | Microsoft Learn
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Your suggestions are valid for SQL server. I am encountering error while connecting to Fabric SQL server.