[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SSRS add in sharepoint 2010

Posted on 2011-02-25
2
Medium Priority
?
522 Views
Last Modified: 2012-06-27
I have successfully installed SQL Reporting Services 2008  on my SQL Server 2008  server, and also installed the add-on for SharePoint 2010, which was installed on my SharePoint server.  I am able to browe - from both the SQL Server & SharePoint server - to the integrated mode reports server:

 

And in here, I see the listing of all of my SharePoint sites.

 

However... if I attempt to view a report through the SharePoint UI or edit a data connection, I get the following error:

 

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 401: Unauthorized.

 

Does anyone have any ideas as to what could be causing this?
0
Comment
Question by:dkumeri
[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
2 Comments
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 1500 total points
ID: 34982580
this sounds like double hop, and the solution is to enable kerberos.

you can read more about double hop here:
http://msdn.microsoft.com/en-us/library/bb283324.aspx
0
 

Author Closing Comment

by:dkumeri
ID: 35199593
thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 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