Forum Discussion
Helper IUnable to connect Fabric Lakehouse using SQL Endpoint in MS Report Server
Unable to connect Azure SQL DB in Fabric from Report Server, I am getting below error. Whereas i am able to connect the same database from report builder.
Error:
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=52; handshake=14946;
Hi, ssesham
Thank you very much for your reply. I have found another solution for you. You can consider the following two solutions:
First, you can use your Azure SQL Server database directly instead of using Fabric hosted Azure SQL Server database.This way you can authenticate with Database User in Report Server and then view your reports normally.If you don't want to connect directly to your Azure SQL Server database, you have the following option:
You can make custom authentication extensions to implement authentication to Azure SQL Server database that has Fabric hosting.
For documentation on custom identity extensions, you can refer to this link below:If you are not familiar with custom identity extensions, you can refer to the examples provided by Microsoft:
Reporting-Services/CustomSecuritySample at master · microsoft/Reporting-Services · GitHub
The second method you need to have an in-depth understanding of programming and then practice it.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
Hi, ssesham
This error you are experiencing may have occurred due to a connection or query issue. The connection timed out because the application was unable to connect to the server. You can find the same bugs as you in the official documentation below, and you need to follow the steps to resolve your current issue:
In addition, you can also follow the following documentation to resolve the issue of the current connection timeout:
Timeout expired messages when connecting to SQL Server - SQL Server | Microsoft Learn
Since Report Server only supports windows authentication and database user authentication, you need to make sure that the average you provide can access your Azure SQL Server Database normally:
You'll also need to make sure you're entering the correct connection string according to the document below:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sseshamThanks Li for the reply.
1) Query Issue: Report is running fine in report builder (which is in my local machine), issue is happening when i uploaded this report in report server (on-prem).
2) Connectivity Issue: I am able to connect the source Dataset (SQL EndPoint in Fabric) from my SSMS and also from other tools like (Power bi Report builder, Power Bi Desktop).
So I am not very much sure, whether I can connect Az SQL DB in Fabric from my Report server or not?
Hi, ssesham
Are you connecting to Lake house in Power BI Report Builder as shown in the following image:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.