KNOWLEDGE BASE

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


Published: 13 Jun 2014
Last Modified Date: 11 May 2016

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.

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.
Did this article resolve the issue?