3 Replies Latest reply on May 29, 2015 3:16 PM by Marty Galvan

    sql server store procedure doesn't work

    hong lu

      I'm new in Tableau. I selected SQL server connection,connected server and select Procedures as connection. I can see the store procedure name in list, after defining parameters and connect, there is always error:

       

      The stored procedure "[dbo].[sp_TurnOver]" does not return a result set.

      Unable to connect to the server "myserver". Check that the server is running and that you have access privileges to the requested database.

       

      I can connect myserver from SQL server management studio. Running the procedure with the same parameters is also fine (definitely has result set here). Why does Tableau give error?