Feb 04 2021 06:35 AM
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
Feb 04 2021 06:52 AM
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
Errors when applications try to connect to SQL Server in Windows - Windows Server | Microsoft Docs