Error "Invalid Precision Value. Unable to connect to the server" Connecting to Stored Procedure

Published: 14 Mar 2016
Last Modified Date: 23 Jun 2016


When connecting to a SQL Server stored procedure in Tableau Desktop, the following error might occur:

[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 9
  • Windows
  • Microsoft SQL Server Stored Procedure


As a workaround, force the column width for a varchar() field.


This error can be caused by a type issue, as only certain types are supported. Work with your database administrator for for information about types.

Did this article resolve the issue?