How to use MS SQL stored proc as data source in JasperReports Server

[a.vandenberkvitalhub.com]

I have a very simple MS SQL stored proc (no input parameters).  See below...

CREATE PROCEDURE dbo.Test
AS
BEGIN

  SET NO COUNT ON

  SELECT * FROM person

END

 

When I use this stored proc as my data source in JasperReports Studio building my report, everything works perfectly.  But when I upload it into JasperReports Server and setup the relevant data sources there, I keep getting an error when the report tries to run.

Any help/guidance is appreciated.  P.S. I'm using the Community Edition of JasperReports Server 6.4.0.

Thank you.

 

[joseng62]

you will need to add some more info here, please. 

What is the error you are getting. 
I would suggest finding the error in the log file and then posting the whole stack trace error, so one can maybe identify where the error is occuring.
There could be a lot of reasons why this is not working as expected.