Forum Discussion
Unable to connect to SQL server
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:
- use IP address instead of server name
- setup "command timeout in minutes" to 2, 10, 100, 100000
- write a custom SQL statement in “SQL statement”
- turn off firewall
- open port 1433
Anyone can help on this issue? Thanks!!!
5 Replies
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, your issue seems very strange to me. I'm trying to involve other senior engineers to have a check on it.
