Getting an error when connecting to SQL Server in Power BI

[shantanugupta]

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

[sboda]

I tried installing ODBC drivers and connectors even after am unable to connect to MySql Database in Power Bi.

[v-robertq-msft · Accepted solution]

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.

[amitchandak]

@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-...

Check This one : https://social.msdn.microsoft.com/Forums/ie/en-US/7419eefe-5f57-4dd1-9604-12db4b544068/prelogin-hand...

[shantanugupta]

@amitchandak I didnot understand " In one solution using IP address in place or URL had worked" what it means?

Can you just elaborate it???

[amitchandak]

@shantanugupta , In the server you are using a URL. Try an IP address of a server like 112.30.21.05 (example)