Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Allisond

PowerBI: Unable to connect with SQL database with Sept Update - Error during Pre-login handshake

Submitted by Advocate II on ‎09-25-2020 05:18 AM

I am all of a sudden getting an error on all of my reports connected to an external db using Windows creds. to login.   This just started occuring 2 days ago and we have yet to resolve.   

 

Error reads: 

Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: HTTP Provider, error: 0 - )

 

Any Help would be so greatly appreciated. 

Status: New
See more ideas labeled with:
29 Comments (29 New)
Comments
GN-MS
Microsoft Employee
Microsoft Employee
‎09-30-2020 12:19 PM

Yes, there will be an update to the desktop as well.

v-chuncz-msft
Community Support
Community Support
‎09-30-2020 08:01 PM

Hi everyone,

 

Power BI customers using the September(SU09) Gateway or Power BI desktop with an on-premises SQL data source that has a self-signed certificate and "Force Encryption" set to Yes may experience issues with reports using Import or Direct Query modes and see the message "A connection was successfully established with the server, but then an error occurred during the pre-login handshake". As a workaround, customers can install a previous version of Gateway and Desktop versions as needed. Engineers have identified the root cause and an ETA for a fix will be provided soon.

 

You may keep an eye on the Awareness.

Anonymous
Not applicable
‎10-21-2020 12:35 PM

Anyone know if the October 2020 release of the Data Gateway has fixed this issue?

musicbydannyd
Advocate IV
Advocate IV
‎10-21-2020 12:39 PM

Excellent question @Anonymous ... I have not yet had a chance to republish any of my broken datasets.

 

Anyone else?

GrantH_SMN
New Member
‎10-21-2020 12:42 PM

@Anonymous, I was told by one of my Power BI Users that on October 15th, Microsoft released an updated version of the September 2020 Power BI Desktop.  My user confirmed that the updated September Update resolved the issue.

I haven't heard anything regarding the Gateway or the October update, but thought this might be helpful.

Anonymous
Not applicable
‎10-21-2020 12:58 PM

@GN-MS; @v-chuncz-msft:

 

Have either of you heard anything about whether the October 2020 update of the Data Gateway has fixed this issue?

GN-MS
Microsoft Employee
Microsoft Employee
‎10-21-2020 01:05 PM

My peer team is confirming that GW has released Oct release with the fix. In fact, GW Oct release came out bit earlier than usual to accomodate availability of the fix sooner.

Anonymous
Not applicable
‎10-21-2020 02:40 PM

@GN-MS,

 

You said your peer teem "is confirming" that the October release of the Data Gateway software contains a fix for this issue. Does that mean your team is currently trying to get confirmation, or that they have already received confirmation? Sorry, it wasn't clear from the wording. 

 

Thanks,

 

James

GN-MS
Microsoft Employee
Microsoft Employee
‎10-21-2020 02:49 PM

Please read it as "has confirmed" :). Oct gateway release is done and has the fix.

Idea Statuses