Forum Discussion

alloowishus's avatar
alloowishus
Helper I
5 months ago

Cannot copy from on prem to Fabric SQL Database

I created the connection, it tests correctly, I can see the database in the destination and select the table. But when I run it I get an error (server and database xxxx'd out by me).   ErrorCode=Sq...
pipelines
alloowishus's avatar
alloowishus
Helper I
5 months ago

I don't understand the question. It is not a VM, I used a cloud connection to connect to Fabric Database as my destination (source is on prem SQL Server db).

lbendlin's avatar
lbendlin
Super User
5 months ago

Your on-prem SQL Server db mandates the use of an On-Prem Enterprise gateway.

  • alloowishus's avatar
    alloowishus
    Helper I
    5 months ago

    Turns out this was a VPN issue.

    • arabalca's avatar
      arabalca
      Super User
      5 months ago

      Hi alloowishus 

      I’m glad to see that you were able to find the solution 😊 From what you described, it seems the issue was related to the Gateway or VPN, which also aligns with the behavior you were experiencing.

      Could you please confirm that everything is now resolved and mark the response as closed?

      Also, please try refreshing and let me know if the issue appears again.

      If this helped solve your problem, I would appreciate it if you could mark the response as the accepted solution and give it a “Like” 👍

      Thanks!

      • alloowishus's avatar
        alloowishus
        Helper I
        5 months ago

        I won't know until I work from home again but I'm pretty sure it's the VPN.