I'm trying to upgrade tableau Dashboards from 6.0 to 8.0.The Upgrade was successful and dashboard looks perfect from my desktop but an error occurs when i try to publish it.I have already tried the Steps mentioned in "Addressing Timeouts when Publishing or Viewing | Tableau Software". I have all the drivers installed.
Here is the error:
An error occurred when publishing the workbook.
SQL Server database error 0x80004005: Login timeout expired
SQL Server database error 0x80004005: 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.
SQL Server database error 0x80004005: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Unable to connect to the server "ABC\XXXXX". Check that the server is running and that you have access privileges to the requested database.
Errors occurred while trying to load the workbook "TestWorkBook". The load was not able to complete successfully.
Response code: 500
Thanks in Advance.
Adding port number of the Sql server in the connection worked great. Wondering why I see this issue when it was working fine on other tableau server (Looks like I have some internal troubleshooting to do) .
Thank you very much !!