SQL Error

[SKC]

Hi, I am trying to run a workflow and I have started getting a new SQL error from a data source I normally don't have any problems with. Can someone help me? Here is the error. Error: Input Data (18): Error SQLExtendedFetch: [Microsoft][ODBC Driver 17 for SQL Server]Error in row[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host. [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure[Microsoft][ODBC Driver 17 for SQL Server]Session Provider: Physical connection is not usable [xFFFFFFFF]. [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure[Microsoft][ODBC Driver 17 for SQL Server]Session Provider: Physical connection is not usable [xFFFFFFFF]. [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure[Microsoft][ODBC Driver 17 for SQL Server]Session Provider: Physical connection is not usable [xFFFFFFFF]. [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure

[gabrielvilella · Accepted solution]

Hi @SKC, please see this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-to-Azure-SQL-Database/td-p/553... 

And this one:

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Error-receiving-data-An-existing-connect... 

[jrsheppard · Accepted solution]

I would check if your SQL Server instance was switched to a different Server, or if any permissions were changed.  You can check if you still have access by going to Start > ODBC Data Sources (64 bit) > Add > ODBC Driver 17 for SQL Server > Enter the correct credentials > Test.  If the ODBC DSN doesn't work, it will spit out a clearer error code.  If there's an error on the ODBC DSN, then it's not an Alteryx issue.