Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sharepoint Integrated Reporting Services Web Parts not showing up.

Posted on 2008-10-14
9
Medium Priority
?
1,294 Views
Last Modified: 2012-05-05
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.  
0
Comment
Question by:McMenHelpdesk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 22716013
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
 

Author Comment

by:McMenHelpdesk
ID: 22716315
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
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 22716373
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:McMenHelpdesk
ID: 22716561
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
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 22716606
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
 

Author Comment

by:McMenHelpdesk
ID: 22716663
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
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 1500 total points
ID: 22716749
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
 

Author Comment

by:McMenHelpdesk
ID: 22735444
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
 

Author Comment

by:McMenHelpdesk
ID: 22762754
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the different options available in the Backstage view in Excel 2013.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question