An error occurred during the pre-login handshake.

[Anonymous]

Hello everyone, I hope you guys could help me.

Im working on Power BI Desktop, I connect to a SQL instance and data loads into Power Query, everything looks fine.

When I try to save the query got the following message:

Query1

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - Se ha forzado la interrupción de una conexión existente por el host remoto.). '.

Appreciate your help and best regards.

[v-piga-msft]

Hi @Anonymous ,

A little confused about your scenario.

Do you connect to remote SQL Server from Power BI Desktop? And is the firewall turned on in the server that installing SQL Server?

If so, please check that if you have added the TCP port and UDP port(1434) in the inbound rule of the Windows Firewall, and you can verify TCP port in SQL Server Configuration Manager.
For more details about configuring remote access for SQL Server, please review the following blog.
https://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/ 

Best  Regards,

Cherry

[Anonymous]

Hello,

Firewall is turned on, my IP is added in it.

I still have the same issue =/

Any other way to fix it?

Appreciate your help.

Best regards.

[Anonymous]

Hey, thank you for the reply.

And yes, Im trying to connect Power BI Desktop to a SQL database thru VPN.

I will check if the Firewall set to on, if so, I will ask my IP Address to be added on Server and let you know.