Forum Discussion
Issue while trying to use an on-premises SQL Server source in Microsoft Fabric pipeline
Hi Rakuka ,
I would take a moment to thank Lodha_Jaydeep , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Hi Rakuka,
Thanks for getting back to me. I’m also using a Free Trial capacity, and the configuration shown in my screenshots is working as expected.
Before we try the new Server/Machine name in Fabric again, could you confirm if you can successfully connect using that same name within SSMS? This helps us rule out any local connectivity issues.
Regarding the error message 'undefined not found in linked-service-registry,' this actually appears to be a Fabric backend service registration failure rather than a misconfiguration on your end or a network issue.
Since you’ve already attempted to re-configure the gateway multiple times without success, we might want to try a different authentication approach.
could you test using Windows Authentication with your specific username to see if that bypasses the registry error? Be make sure to not skip connection you can get the window Auth user name from the SSMS and password should be used for the log-on to the machine.
I’m happy to keep digging into this with you. If this helps resolve the issue, please consider marking this as the Accepted Solution so it can help other community members. Kudos are always appreciated!
Thank you for the follow-up, Lodha_Jaydeep
Yes, we already completed that validation. Connectivity was tested from SSMS on the same machine where the gateway is installed, and port 1433 is working. Multiple server-name formats were also tested during troubleshooting, including localhost,1433, machine-name based formats, and named-instance style formats. In addition, the OneBridge gateway is online and the gateway Network ports test completed successfully (34/34 passed).
We also agree that the undefined not found in linked-service-registry message looks more like a Fabric backend/service registration issue than a local SQL Server, gateway, or firewall issue. That is consistent with the fact that the problem persists even after repeated reconfiguration, connection recreation, workspace changes, and browser changes.
Windows Authentication was also attempted earlier, in addition to SQL authentication, and neither path made the connection fully usable inside Fabric Copy activity. Based on the full set of checks completed so far, this now appears to be beyond a basic connectivity or authentication configuration issue.
Hello Lodha_Jaydeep & tayloramy,
Yesterday when i contacted Microsoft on this issue, I recieved a reply which is as follows.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please note that the West India region currently does not support the use of an on-premises data gateway for Data Factory pipelines. As a result, if your Data Factory is deployed in the West India region, you will not see the option to select an on-premises data gateway while creating a pipeline connection.
Additionally, even if a connection is created, it may not appear under the Connections section within pipeline activities.
For more information, kindly refer to the known issues documentation below for your reference.
Please let me know if you have any questions.
Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
So, which region you guys are using, can you check and let me know please? Is everything working fine at your end?
If possible, can I change my region now or in the next billing cycle (I doubt it's not a paid version)
thank you.
Rakuka
Hi Rakuka,
Thank you for the update, I’m glad we have identified the root cause. As we suspected, this is not a configuration error, but rather a limitation where certain trial features are not supported in all regions.
I am currently operating within the Central India region.
Could you please check the Workspace settings for the pipeline and confirm if it is currently assigned to the North India region?