Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, does anyone have the same issue before?
I was trying to connect SQL server, called it server A and server B.
I can connect both servers on other apps, and I have no problems to get databases.
On Power BI, I can only connect to server A.
On server B, it shows --- Details: "Microsoft SQL: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment. 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=18201; handshake=14361; "
There are something I tried but nothing work:
Anyone can help on this issue? Thanks!!!
1). Do you try to connect to SQL on Server B via Power BI Desktop or Power BI online service?
2). Did you ever tried to connect to that SQL via SSMS on the same machine you have questions?
3). Can you successfully ping Server B IP address?
Hi,
I am trying to connect SQL on Server B via Power BI Desktop.
I tried to ping the IP address, it was 100% receive. And I could connect SQL via SSMS on the same machine.
Anything I can do on it?
Thanks for your help!!!
@tryingPowerBI, could you please help to provde the following information?
Download link for Wireshark
Wireshark:
4. Select the connection that the traffic is processing on. In my screenshot below, this is Etherne
5. Click on Start
6. Recreate the connection and/or refresh issue
7. As soon as the issue is recreated, come back into Wireshark and click on "Stop"
8. Save the file by going to File > Save As
Download Link for Message Analyzer
Steps to capture the network trace:
Message Analyzer:
3. Click on Live Trace
4. Ensure that you are using "Localhost" as the Target Computer
5. Click on Select Scenario
6. Select "Local Network Interfaces"
7. Change the Parsing Level to "Network Analysis"
8. Click on Start
9. Recreate the connection and/or refresh issue
10. As soon as the issue is recreated, come back into Message Analyzer and click on "Stop"
11. Save the file by going to File > Save As
@tryingPowerBI, your issue seems very strange to me. I'm trying to involve other senior engineers to have a check on it.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |