Error when setting destination in copy data activity (MS Fabric)

[johnnydevv]

Hi all,

In my Fabric workspace, I have a pipeline with a "Copy Data" activity.

The source is a lakehouse.

I am trying to set the destination to be SQL Server.

I have put in the server name, username and password. I also checked the checkbox for "Use encrypted connection".

When I click connect, I get this error (The remote computer refused the network connection), shown in snapshot below:

I also have remote connections enabled via SSMS,

My SQL Server instance is running on a Docker container (which was turned on the whole time I tried connecting from Fabric).

Please help.

Many thanks!

[johnnydevv]

Thanks @Anonymous ! It worked.

Installing a standard gateway was the missing piece for me. Once I did that, I was able to create the connection as you outlined.

Thanks a million!

[Anonymous · Accepted solution]

Hi @johnnydevv ,

Thanks for the reply from lbendlin .

According to your description, are you trying to write Lakehouse data to SQL Server? I tested it and it is possible. The gateway needs to be configured in advance, here are the steps I tested.

Configure the gateway connection of the corresponding database of the SQL Server you want to connect to, as shown below:

Use the pipeline's Copy data assistant.

Select a table in a lakehouse as a data source.

After selecting SQL Server Database in the Destination stage, enter the corresponding database information. This information needs to be consistent with what you entered when configuring the gateway. The system will automatically select the corresponding gateway, and then select Next.

Finally, click Save and Run.

This is the result after a successful run.

Go to the corresponding database of SQL Server and you can see that the table has been loaded.

If this doesn't help you resolve the issue, please try to let me know what you did.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lbendlin]

You are trying to write back into an on-premise storage?  I don't think that is supported.  But you can do it the other way round - from your SQL sever connect to the SQL endpoint of the Lakehouse.