SSRS report with stored procedure- permission to normal domain user

How can I give permission to normal domain user for ssrs report I created using stored procedure.
Only if I add the user in Domain Admin group- he can see the report, other wise not,
Please suggest any way so that normal users can see the report
http://blog.hoegaerden.be/2009/11/10/reporting-on-data-from-stored-procedures-part-1/
Thanks
sharepointDepotAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Give this a whirl..
GRANT EXEC ON OBJECT::your_stored_procedure_name TO your_user_name

Open in new window

0
Preston CooperDatabase AdministratorCommented:
Yes to the execute permissions stated earlier, but also check and make sure the user has read permissions to the SQL Server database as well.  Then check the SSRS permissions for the report.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
sharepointDepot, do you still need help with this question?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sharepointDepotAuthor Commented:
Hi Jim,
I did this as solution but it wont worked ,so on priority basis I gave permissions to 2 users with bit more level, but for all users, I required to find the solution,
sorry for bit delay in reply since -I am in midst of few urgent things-will keep you posted on same line asap,please share your suggestion also
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Giving permission for an AD group doesn't work?
0
sharepointDepotAuthor Commented:
Hi Guys,
None of above solutions actually worked as a solution to my questions, so dont know how to close the questions
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sharepointDepotAuthor Commented:
Hi, none of above mentioned solutions worked as a result I was unable to post further , So whatever is Grade, I wanted to close as suggested answers  were  first sight googled answers,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.