Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
11 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
pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
11 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

 

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

Hi pmscorca ,

 

The error is definitely a Windows installation error.

Have you checked the system requirements?

 

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

 

I've had this error before, and here's what I did.

1. Uninstall
2. Restart the system
3. Install

That worked by me.

 

If that doesn't help, you'll need to check whether there are any old directories or remnants on your system that are preventing a new installation.

 

Best regards

 

  • pmscorca's avatar
    pmscorca
    Icon for Post Prodigy rankPost Prodigy
    11 months ago

    Hi, thanks for your reply.

    I'm trying to reinstall after the uninstallation and the restarting of the machine but unsuccessfully.

    Which could be the remnants to eliminate? Thanks
    It's very hard to understands the logs.

      • pmscorca's avatar
        pmscorca
        Icon for Post Prodigy rankPost Prodigy
        11 months ago

        Hi,

        I've tried to delete register keys related to the OPDG and the remnants folders, but unsuccessfully.

        I've tried to reinstall the November 2025 version, but unsuccessfully.

        I've checked the .NET Framework: is the 4.8 one.

        The operating system is Windows Server 2025 Datacenter.

        I remember that I've installed the November 2025 version successfully, I've uninstalled it successfully to install the October 2025 version successfully and then I uninstalled it successfully.

        I think that an important software like OPDG should have a separate or integrated certified tool that allows you to check the prerequisites and clean up in case of uninstallation; by this software it is possible to connect to on-premise data sources!
        It doesn't seem a more stable software: some users have solved in a manner, other users in another manner, and so on.