I have uploaded workbooks to Tableau Online and get the following error whenever I try to run a refresh (scheduled or manual). The data source is Microsoft SQL Server and I am publishing with Publish Type: Embedded in Workbook and Authentication: Server Run As Account. Why do the extract refreshes always fail like this?
Connectionless Failure ( status code = 10000, There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs. Kerberos RunAs authentication is not enabled on Linux [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2AF9 [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
@Matthew Davidson
Hi, recommend you to change the authentication to username and password. Create a user with password in MS SQL Server, edit the connection using Tableau Desktop (recreate the extract) and republish the datasource to Tableau Server.
In this case, Linux does not use a Run as User Account, as it does with Windows. However if you use Kerberos you may use a Run as User Account: https://help.tableau.com/current/server-linux/en-us/kerberos_runas_linux.htm. However, I think the path to create a username in Ms SQL Server is shorter and faster.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
