KNOWLEDGE BASE

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


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

Issue

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. 

Environment

  • Tableau Desktop 9
  • Windows
  • Microsoft SQL Server Stored Procedure

Resolution

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

Cause

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?