Forum Discussion
Getting an error when connecting to SQL Server in Power BI
I am not able to connect to SQL sever in Power BI. Can anyone help me to fix that issue?
"We encountered an error while trying to connect details: "Microsoft SQL:Connection timeout expiered. 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=115; handshake=29882; "
Attach Picture.
Problem-1Problem-2
Hi, shantanugupta
Have you followed amitchandak’s suggestion to try IP address instead of using server name and check if it can work?
If not, you can also try these steps that may help according to my research:
- check the login details and server name
- login to SQL Server Management Studio with same details
- turn off proxy.
- turn off the firewall.
- check if all TCP\IP configurations in the configuration manager enabled.
- check all set to port 1433
Here are some cases that have a similar error as yours, you can also take a look:
https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/28645
https://community.powerbi.com/t5/Desktop/sql-connection-time-out-from-power-bi-desktop/m-p/17307
https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-SQL-server/m-p/79157
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
shantanugupta , There is some issue with URL.
In one solution using IP address in place or URL had worked
other one refer: https://stackoverflow.com/questions/60520909/failed-to-connect-from-sql-server-database-to-ms-power-bi-desktop
amitchandak I didnot understand " In one solution using IP address in place or URL had worked" what it means?
Can you just elaborate it???
shantanugupta , In the server you are using a URL. Try an IP address of a server like 112.30.21.05 (example)
Hi, shantanugupta
Have you followed amitchandak’s suggestion to try IP address instead of using server name and check if it can work?
If not, you can also try these steps that may help according to my research:
- check the login details and server name
- login to SQL Server Management Studio with same details
- turn off proxy.
- turn off the firewall.
- check if all TCP\IP configurations in the configuration manager enabled.
- check all set to port 1433
Here are some cases that have a similar error as yours, you can also take a look:
https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/28645
https://community.powerbi.com/t5/Desktop/sql-connection-time-out-from-power-bi-desktop/m-p/17307
https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-SQL-server/m-p/79157
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
