[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • Last Modified:

SSRS add in sharepoint 2010

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
dkumeri
Asked:
dkumeri
1 Solution
 
zephyr_hex (Megan)DeveloperCommented:
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
 
dkumeriAuthor Commented:
thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now