A service account in tableau is facing the following error when trying to access stored procedures and views:
Error message Connection Failure (status code = 3000, [Microsoft][ODBC Driver 17 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. [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. Unable to connect to the Microsoft SQL Server server "Server\Instance". Check that the server is running and that you have access privileges to the requested database.)
I have tried the following things to troubleshoot:
- made sure the correct server name is being specified
- there are no alias's set
- this instance is using the non-default port
- tried to login to Tableau using variations of styles: <servername>, portnumber
- SQL Browser is started
- able to ping the server name only. unable to ping server\instance (this is expected)
- TCP/IP is enabled
What other things can I do to further troubleshoot and resolve this issue? Thank you in advance