Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
9 months ago
Solved

Error during pipeline creation to read from a SQL Server: The Data Factory runtime is busy now

Hi, I need to import data from a SQL Server on-premise source. So, I've installed the OPDG in a local machine using a local user account with the necessary administrator privileges; registered t...
Need Help
pipelines
  • spaceman127's avatar
    spaceman127
    9 months ago

    Hi pmscorca ,

     

    That is a crucial clue.

    According to the installation file for the November update, official support is only provided up to Windows Server 2022.

    I think this is where the problem lies. Even if you were able to install it, that doesn't mean it will work again.
    Officially, 2025 is not yet supported.
    Of course, there is no mention of this in the documentary.

    See screenshot.

     

    Here the documentation again.

     

    https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install#requirements

     

    Please install the On Premise Data Gateway on Server 2019 or Server 2022. If that doesn't work, you could contact support. 


    If it works, then we can help you with your other problem, if it has already been solved with this.

     

    Best regards 

     

     

     

  • spaceman127's avatar
    spaceman127
    9 months ago

    Hi pmscorca ,

     

    of course, that cannot be explained.

    Please let us know if you have installed it on a different server operating system.
    If your original problem still persists, we can then continue to investigate.

     

    Feel free to leave kudos or accept it as a solution. This will also help other community members.

     

    Best regards

     

spaceman127's avatar
spaceman127
Icon for Super User rankSuper User
9 months ago

Hi pmscorca,

 

I suspect it's an authorization issue.

From what I gather from your description, the gateway connection is working and you have access.

But what interests me now is, what credentials are you using to establish the connection?
I suspect that's where the problem lies.

When establishing the connection, could you switch to Basic for a moment and use SQL Server authentication, then test it?

 

I assume you've already worked through the Microsoft articles on this topic.

 

Best regards

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
9 months ago

Hi, thanks for your replies.

Inside Fabric, I need to use connection with basic authentication (SQL Server authentication): it is the unique authentication mode that I can use.

After I've uninstalled the November 2025 OPDG and I've installed the October 2025 one I've noticed that the network ports test fail; so I've uninstalled and reinstalled the October 2025 OPDG but the setup fails with this error (code = 1601):

It's very hard to understands the logs.

I need to solve the setup issue as the first thing.

Thanks