Sharepoint Integrated Reporting Services Web Parts not showing up.

For some reason on our Moss box we can't seem to get the sharepoint RS web parts to show up.  Not the vanila report veiwer and expolorer the Sql report viewer.  
McMenHelpdeskAsked:
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.

zephyr_hex (Megan)DeveloperCommented:
have you already configured SSRS for integration mode?  and then installed the report web viewer add in?

in my experience, ssrs & sharepoint integration can be tricky.  if you don't follow the configuration steps IN ORDER, stuff doesn't work right.

http://mikewalsh.bilsimser.com/PermaLink,guid,3ff1194c-3b48-4f35-9797-a03327db8d00.aspx
0
McMenHelpdeskAuthor Commented:
i read that article when i was installing everything, and it all looks good.  The problem that i'm having is when i connect the report viewer to the report explorer the site errors and i have to go and close the wep part manually.
0
zephyr_hex (Megan)DeveloperCommented:
so if i'm understanding correctly...
ssrs shows a green light for sharepoint integration
you were then able to go into central admin and configure Report Integration settings...
you can see the sql report web part in the list of available web parts...
but they are giving you a problem when you actually use them.

yes?

if this is the case, please post exact errors that you see.  if no errors show in the user interface, please check Event Viewer on your web front end server.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

McMenHelpdeskAuthor Commented:
error is the awesome sharepoint error:

An unexpected error has occurred.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.

if you try to open the page again, throws this error.  when you click on the link you can close the viewer web part, and the page works again.

0
zephyr_hex (Megan)DeveloperCommented:
i'm assuming that you've configured the viewer to display a report.  are you able to view this report outside of sharepoint?  does this happen with all reports, or just one?

can you also see if Event Viewer on the web front end server has a more specific error?
0
McMenHelpdeskAuthor Commented:
what i did was open up the report explorer web part, browse to the report, open it up, then go to connections> show report in > report viewer.

i didn't do any specific configuration for the viewer web part.

yeah i can view it outside of share point

this seems to be the error in event viewer

Request for the permission of type 'Microsoft.SharePoint.Security.SharePointPermission, Microsoft.SharePoint.Security, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
zephyr_hex (Megan)DeveloperCommented:
i haven't encountered that error myself..
but it seems to be related to the Trust Level on the report viewer web part.

if you read the comments on this blog:
http://aspalliance.com/729

there seems to be several people who had problems with the viewer... and changing the trust level from WSS_Minimal to WSS_Medium resolved the problem for them

make sure you make a safe copy of web.config before editing it.
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
McMenHelpdeskAuthor Commented:
it seems my problems actually stem from different web apps being created with different accounts.  the SQL report services add-ins were installed on Central Admin web app but not on any other ones.  Thanks for your help and attention
0
McMenHelpdeskAuthor Commented:
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
Microsoft Applications

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.