Forum Discussion
Lakehouse Connection issue using SQL Endpoint
Hi v-nmadadi-msft , We found the solution for the issue. For lakehouse, the connection gets rerouted to some different URL. Initially we were tokenizing it and trying to connect to it, but the trick is you need to perform socket , prelogin on the original end point and "send the redirected URL to the login stage" while using the TDS protocol. PFB sample :
original Sql end point : nkttul5irfuejgeufneefoktjm-obtyxdfizvlura7ao2yincxurq.datawarehouse.fabric.microsoft.comRedircted URL : pbipneu9-northeurope.pbidedicated.windows.net\ABCDUL5IRFUEJGEUFNEEFOKTJM-CCSJOZJPH6FE5GFNZMCN4ILWLA-dw:1433
Existing code logic trying to connect : pbipneu9-northeurope.pbidedicated.windows.net
Hi Pratik_0527
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Thanks and regards
Hi v-nmadadi-msft the issue is still there. We are not able to connect yet. Also some of the solutions suggested were using highend APIs like REST which our current code is not dealing with. We are working with Microsoft fabric team and will update here as soon as we get any break through
Hi Pratik_0527 ,
Thank you for providing an update to your issue. As suggested please explore modifications to your code to integrate REST API.
Also kindly update the community members if there is any breakthrough with Fabric team so as to help other members who may face similar issue in the future.
Thank you
Hi v-nmadadi-msft , We found the solution for the issue. For lakehouse, the connection gets rerouted to some different URL. Initially we were tokenizing it and trying to connect to it, but the trick is you need to perform socket , prelogin on the original end point and "send the redirected URL to the login stage" while using the TDS protocol. PFB sample :
original Sql end point : nkttul5irfuejgeufneefoktjm-obtyxdfizvlura7ao2yincxurq.datawarehouse.fabric.microsoft.comRedircted URL : pbipneu9-northeurope.pbidedicated.windows.net\ABCDUL5IRFUEJGEUFNEEFOKTJM-CCSJOZJPH6FE5GFNZMCN4ILWLA-dw:1433
Existing code logic trying to connect : pbipneu9-northeurope.pbidedicated.windows.netHi Pratik_0527 ,
We really appreciate your efforts and for letting us know the update on the issue.
Please accept your reply as the solution so as to help other community members who may come across this post in the future.Additionally continue using fabric community forum for your further assistance.
Thank you