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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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 Data DudeCommented:
Give this a whirl..
GRANT EXEC ON OBJECT::your_stored_procedure_name TO your_user_name

Open in new window

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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
sharepointDepot, do you still need help with this question?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Giving permission for an AD group doesn't work?
sharepointDepotAuthor Commented:
Hi Guys,
None of above solutions actually worked as a solution to my questions, so dont know how to close the questions

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,
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

From novice to tech pro — start learning today.