A connection was successfully established with the server, but then an error occurred during the pre

Occasional Contributor

@Sergei Baklan 

I'm trying to use parameters in power query. I am now having a new error appear:

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 - An existing connection was forcibly closed by the remote host.)
Details:
    DataSourceKind=SQL
    DataSourcePath= (some server name)
    Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
    ErrorCode=-2146232060
    Number=10054
    Class=20

I'm connecting to a Linux server, OS: 3.16.0-4-amd64.

Typically, when connecting to it I go to get Data -> Odbc -> and then select the DSN and paste my SQL statement in the advanced options ... and it works perfectly

 

Now I'm trying to use the following M code and it is giving me the error shown above

Source = Sql.Database(Server, Database,.....)

Thank you for the help

1 Reply

@cl27274 

Sorry, but that's out of my competence. What I'd that's first check in Data->Data source settings if they are correct for that source.

However, perhaps that's not Power Query issue. I googled a bit and first what found

A connection was successfully established with the server, but then an error occurred during the pre...

 

Errors when applications try to connect to SQL Server in Windows - Windows Server | Microsoft Docs