Geek asks and answers

Reporting Services: use procedure as dataSet?

I start with Reporting Services. I am running SQL 2008 R2 Standard. Reporting Services runs on a single server.

I created a stored procedure that takes one intas a parameter. In SQL Server, I have no problem running this as user "A".

I have created a generic SQL connection (with user sql A) and I am creating an inline dataset. When I click on the "Saved Procedure" button, I have to fill in some information. I installed a Windows user who is allowed to connect to Reporting Services.

After that, I have a list of stored procedures, but not the one I created: stored procedure list

But I set all permissions for user A: TestProcedureSubjectUsage

What am I missing?

I created my stored procedure before I created my project.

+5
source share
2 answers

I finally finished by specifying the name of the procedure, and it works, it just cannot display them in the list.

0
source

This sounds like a permission issue. Check the credentials that you use in the DataSource (not the DataSet) - it must be "UserA", or you need to assign permissions to log into the DataSource.

0
source

More articles:


All Articles