Aug 03, 2016 We are pleased to announce the full release of the Microsoft ODBC Driver 13.1 for SQL Server. The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database for C/C based applications. What’s new Always Encrypted You can now use Always Encrypted with the Microsoft ODBC Driver 13.1 for SQL Read more.
I am trying to connect to Microsoft SQL Server from Tableau Online and I am getting the below error message:
Can’t connect to Microsoft SQL Server
Detailed Error Message
Odbc Driver For Sql Server
[Microsoft][ODBC Driver 13 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired
[Microsoft][ODBC Driver 13 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 server 'server-name'. Check that the server is running and that you have access privileges to the requested database.
1. This article 'Login timeout expired' Error When Refreshing Extract | Tableau Software mentioned
Odbc Driver 13 For Sql
If the computer running Microsoft SQL Server uses the Named Pipes client protocol, configure Microsoft SQL Server to use TCP/IP instead. - In my case we have both protocols enabled.
2. Tried using IP address vs DNS name
Would appreciate if someone can point me in the right direction or material.