KNOWLEDGE BASE

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


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

Issue

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.

Environment

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

Resolution

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"
https://msdn.microsoft.com/en-us/library/ms173839.aspx

Description of "sp_describe_first_result_set"
https://msdn.microsoft.com/en-us/library/ff878602.aspx
Did this article resolve the issue?