KNOWLEDGE BASE

Error "[Microsoft][SQL Server Native Client 11.0]Invalid precision value" Using Stored Procedure


Published: 13 Jun 2014
Last Modified Date: 01 Nov 2017

Issue

When defining the connection using a stored procedure, the following error might occur:

An error occurred validating the stored procedure connection.
[Microsoft][SQL Server Native Client 11.0]Invalid precision value
Unable to connect to the server "server name." Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • MS SQL Server

Resolution

Option 1

Ensure that there is only one SQL Server driver (Microsoft SQL Server <version> Native Client) installed on the computer running Tableau Desktop.

Option 2

Work with your database administrator to ensure that the stored procedures run correctly in SQL Server.

Option 3

Save the stored procedure as a view in the database, and connect to that instead. 

Cause

The error is a pass through error from the custom SQL and can occur due to multiple SQL Server drivers being installed on the same computer.

Sometimes, this error returned to Tableau Desktop typically relates to wrong data types.
Did this article resolve the issue?