Forums

Administration & IT Assorted issues with BIDS/SSRS

Assorted issues with BIDS/SSRS

Daniel Reid $organization over 11 years ago

Hi there,

I am attempting to create a custom report, and I'm having a few little issues.

I have gotten the SQL together and created the stored procedure, but I try to execute it, I get this error:
"The EXECUTE permission was denied on the object 'LRP_MONA_TicketDesignElements', database 'impresario', schema 'dbo'."
I am also getting this result when I try to import the dataset into BIDS. Do I need to mess with my permissions - and can I do that without compromising overall security?
I have created a report directly in BIDs (by copying in the SQL, rather than using a stored procedure). However I'm not sure how to deploy it; what do I need to set TargetServerURL as?
After deploying it, I then have to add it to the Report Setup System, correct? I have exported an xml file to modify and re-import. But how do I actually link it to my newly-created report? Is it the datawindow?

Thanks!
Daniel.
daniel.reid@mona.net.au

Parents

Caryl Jones $organization over 11 years ago

Normal 0 false false false EN-GB X-NONE X-NONE
In answer to the first question, it doesn't sound like you gave ImpUsers permissions to the SQL. Right click on LRP_MONA_TicketDesignElements and go to Properties, Permissions and add ImpUsers with Execute rights, this should solve problem one.

I’d take a look at the Custom Report Setup document, found here: http://www.tessituranetwork.com/network/Learning/Documentation/Customization.aspx

And also the SSRS T-Casts here: http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/IT.aspx which should help answer the other questions.

Caryl
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Caryl Jones $organization over 11 years ago

Normal 0 false false false EN-GB X-NONE X-NONE
In answer to the first question, it doesn't sound like you gave ImpUsers permissions to the SQL. Right click on LRP_MONA_TicketDesignElements and go to Properties, Permissions and add ImpUsers with Execute rights, this should solve problem one.

I’d take a look at the Custom Report Setup document, found here: http://www.tessituranetwork.com/network/Learning/Documentation/Customization.aspx

And also the SSRS T-Casts here: http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/IT.aspx which should help answer the other questions.

Caryl
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Daniel Reid $organization over 11 years ago in reply to Caryl Jones

Hi Caryl, - sorry, I only just saw this reply! I might need to look at my notification settings.

That has been a great help, thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel