Here is the error is get:
UNKNOWN: 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.
[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
@Sumit Mondaiyka
The most common cause is that your MS SQL Server is not accessible from the computer where you are running Tableau Bridge.
So to confirm, you can use telnet: e.g: Test if AL008DB server can connect on port 1433 (1433 is the default port for MS SQL, but your DB administrator could change it)
Using hostname
telnet AL008DB 1433
Using IP
telnet 192.168.0.1 1433
The second cause would be that you are not using the correct port. This happens frequently for published Databases. As a common security measure, the port used outside of the company is different from the port used in the company.
The third reason would be a firewall issue in your MS SQL that would not allow connections from the computer/server where you installed Tableau Bridge.
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
Tableau Ambassador
