Forum Discussion
Post ProdigyError during pipeline creation to read from a SQL Server: The Data Factory runtime is busy now
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
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
Post ProdigyHi, 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
Super UserHi 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
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.- spaceman127
Hi pmscorca ,
first.Can you Share your Logs?
And here you find an other article to clean the installation.
That would be my first step.
Best regards
- pmscorca
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.