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!
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.
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=,'