question

SQLLover21-0870 avatar image
0 Votes"
SQLLover21-0870 asked Criszhan-msft answered

Unable to connect to SQL Server using Tableau

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



sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

The error message means that the SQL Server instance is not reached.

You have a couple items on your list, you don't mention firewalls. The firewall must also permit UDP 1434, if you want to connect by instance name.

I should add that I am not familiar with Tableau.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hi,

You can also try to connect to SQL Server using SSMS and refer to the following documents to Troubleshoot connecting to the SQL Server Database Engine.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.