topic Re: Copy data from on-premise database to Fabric SQL database in Data Engineering

Copy data from on-premise database to Fabric SQL database

Hemant_Patel — Fri, 07 Feb 2025 09:30:46 GMT

In Fabric data pipeline, I am trying to copy data from on-premise database to Fabric SQL database.

I am using service principal to authenticate with Fabric SQL database. I validated the authentication of the service principal with Fabric SQL database using SSMS and it works.

I am getting below error :

ErrorCode=UserErrorInvalidPluginType,'Type=Microsoft.DataTransfer.Common.Shared.PluginNotRegisteredException,Message=Invalid type 'FabricSqlDatabase' is provided in 'linkedServices'. Please correct the type in payload and retry.,Source=Microsoft.DataTransfer.ClientLibrary,'

Any idea how to resolve this .

Re: Copy data from on-premise database to Fabric SQL database

nilendraFabric — Fri, 07 Feb 2025 12:42:39 GMT

Hello @Hemant_Patel

For copying data to a Fabric SQL database, you may need to use `AzureSQLDatabase` linked service type.

please give it a try.

Re: Copy data from on-premise database to Fabric SQL database

Hemant_Patel — Fri, 07 Feb 2025 13:56:30 GMT

@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=,'

Re: Copy data from on-premise database to Fabric SQL database

v-aatheeque — Mon, 10 Feb 2025 06:09:42 GMT

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!

Re: Copy data from on-premise database to Fabric SQL database

Hemant_Patel — Mon, 10 Feb 2025 10:05:58 GMT

Your suggestions are valid for SQL server. I am encountering error while connecting to Fabric SQL server.

Re: Copy data from on-premise database to Fabric SQL database

imrankhan0 — Mon, 10 Feb 2025 10:52:57 GMT

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!

Re: Copy data from on-premise database to Fabric SQL database

v-aatheeque — Wed, 12 Feb 2025 07:14:55 GMT

Hi @Hemant_Patel ,

As suggested by @imrankhan0 @nilendraFabric , we wanted to check if your issue has been resolved ?

If their response addressed your query, kindly mark it as "Accept Answer" and click "Yes" if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

Re: Copy data from on-premise database to Fabric SQL database

v-aatheeque — Mon, 17 Feb 2025 10:38:14 GMT

Hi @Hemant_Patel ,

Has the response from @nilendraFabric @imrankhan0 resolved your issue?

If it did, please consider marking the helpful reply as the accepted solution—this helps other community members with similar questions find answers more easily.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

Re: Copy data from on-premise database to Fabric SQL database

v-aatheeque — Sun, 23 Feb 2025 16:15:48 GMT

Hi @Hemant_Patel ,

As suggested by @imrankhan0 @nilendraFabric , we wanted to check if your issue has been resolved ?

If their response addressed your query, kindly mark it as "Accept Answer" and click "Yes" if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum