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

Published: 13 Jun 2014
Last Modified Date: 31 Jan 2017


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.


  • Tableau Desktop
  • MS SQL Server


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.


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?