cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tomas85
Microsoft
Microsoft

Unable to Connect to SQL Server

Hi Guys, does anybody has the similar issue? I was unable to connect SQL Server ... Details: "Microsoft SQL: Connection Timeout Expired. 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=18492; handshake=10273; " so I am not able to get DATA.

I can connect through my MS SQL Management Studio with Connection time-out setup = 60 seconds ...

 

I have tried to setup "Command timeout in minutes" = 2 in PowerBI and still no luck. I went through the similar articles here and this function has not been supported yet?

1 ACCEPTED SOLUTION
Tomas85
Microsoft
Microsoft

Hi,

We were able to fix the issue with MSIT Support Team. You should try IP address instead of putting server name there ...

View solution in original post

5 REPLIES 5
Tomas85
Microsoft
Microsoft

Hi,

We were able to fix the issue with MSIT Support Team. You should try IP address instead of putting server name there ...

View solution in original post

Hi,

 

I have the same issue, using IP instead of server name.

 

Is there any other suggestion?

Hi there,

 

actually no, only server name or IP address.

 

You should contact support team, they are really quick and can help you.

v-yuezhe-msft
Microsoft
Microsoft

Hi Tomas85,

As indicated in this blog, we are able to specify a command timeout value (in minutes) when connecting to SQL Server database with the March release of Power BI Desktop.

Could you please set the value of "Command timeout in minutes" to a higher value and check if you can connect to SQL Server successfully? Also write a custom SQL statement in “SQL statement” and check if the connection is established or not.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia,

 

Im getting the same errors as Tomas.

I also tried setting high value in the "Command timeout" box or writing a custum SQL statement.

 

Still the connection is not established..

 

Do you know other alternative?

 

Thanks,

Mor  

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors