Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
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 the installed OPDG using a Microsoft Entra ID service account;
  • tested the installed and registered OPDG;
  • shared with my Microsoft Entra ID account the data gateway in Fabric;
  • created the on-premise connection using my Microsoft Entra ID account in Fabric.

I'm working in a new Fabric environment (F8 capacity), inside a new and unique workspace. My Microsoft Entra ID account has the admin role for this workspace.

In Fabric, I've checked the status of the data gateway and the related connection: they are on-line.

I'm trying to create the first pipeline with a copy activity: I've specified the connection, the connection type (SQL Server) and then I've run the test connection obtaining this error (error code = 9518):

In the Fabric environment there aren't any other pipelines or dataflow gen2s.

Well, any helps to me in order to solve a such strange issue, please?

Many thanks


Update this post: I've tried with both November 2025 and October 2025 OPDG, but the issue remains. Thanks

 

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

     

12 Replies

  • spaceman127's avatar
    spaceman127
    Super 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
      Kudo Kingpin
      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

       

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    9 months ago

    Hi pmscorca ,
    Thanks for reaching out to the Microsoft fabric community forum.


    In addition to the valuable point mentioned by pmscorca , Please check out this point which test if the issues lies with lack of access to ports.

    To test if the gateway has access to all the required ports, run the network ports test. The results of the test are either Completed (Succeeded) or Completed (Failed, see last test results). If the test succeeded, your gateway successfully connected to all the required ports. If the test failed, your network environment might be blocking these required ports and servers.

     

    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    8 months ago

    Hi pmscorca 

    I wanted to check if you had the opportunity to review the valuable information provided by spaceman127 . Please feel free to contact us if you have any further questions.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    8 months ago

    Hi pmscorca 

    May I check if this issue has been resolved by points provided by spaceman127 ? If not, Please feel free to contact us if you have any further questions.


    Thank you