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.
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.
Yes, there will be an update to the desktop as well.
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.
Anyone know if the October 2020 release of the Data Gateway has fixed this issue?
Excellent question @JBartlettHV ... I have not yet had a chance to republish any of my broken datasets.
@JBartlettHV, 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.
Have either of you heard anything about whether the October 2020 update of the Data Gateway has fixed this issue?
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.
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.
Please read it as "has confirmed" :). Oct gateway release is done and has the fix.