Stored Procedure on MS Sql Server returns error message:The protocol is disconnected!

Published: 22 Mar 2017
Last Modified Date: 03 Apr 2017


When connecting to a stored procedure on MS SQL Server through the native client 11.0 SQL Server driver, a 'The protocol is disconnected' error is received. Part of the stored procedure contains a 'SET FMTONLY' statement.


  • Tableau Desktop 10.1.5
  • Win 7
  • MS SQL Server - Native Client 11.0 Driver


Replace the SET FMTONLY statement with sp_describe_first_result_set (Transact-SQL). See the following links:

"SET FMTONLY" is in the process of being replaced - "Do not use this"

Description of "sp_describe_first_result_set"
Did this article resolve the issue?