tryingPowerBI's avatar
tryingPowerBI
Frequent Visitor
9 years ago
Status:
New

Unable to connect to SQL server

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

2 Comments

  • PowerBI currently times out connections in less than 15seconds. Please increase this timeout to 30 seconds, or use the property provided in the ODBC connection string!

Recent ideas