Solved

SSRS sharepoint

Posted on 2011-02-16
6
997 Views
Last Modified: 2012-06-27
I have SSRS 2008 integrated with sharepoint 2010,when I am trying to open the data source of a report, it showing 401 error. Where should I look

(Error
The request failed with HTTP status 401: Unauthorized.
Troubleshoot issues with Microsoft SharePoint Foundation. )
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
  • 3
  • 3
6 Comments
 
LVL 7

Expert Comment

by:arduk
ID: 34910859
I would start by checking your kerberos configuration.

This sounds (with the limited information that has been provided) like it may be as a result of the double hop issue.

If your datasource connects to server other than your sharepoint server, the sharepoint server will not be able to pass your credentials through if you are using NTLM authentication - you will need to either configure the datasource to use a specific user account, or you will need to configure Kerberos so that your credentials can be passed through.

Hope this helps...
0
 

Author Comment

by:dkumeri
ID: 34911016
How I can configure the datasource to use a specific user account?
0
 
LVL 7

Expert Comment

by:arduk
ID: 34911055
assuming you are connecting to a database, you can specify the user account in the connection string....see http://connectionstrings.com for samples of just about every connection string you will ever need...
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:dkumeri
ID: 34911298
I guess bit of misunderstanding.
The problem is - when I upload a ssrs report in SharePoint library and when click on the options and try to open the data source then it shows the error. I can't even see the data source. I have attached images.
Error.JPG
0
 
LVL 7

Accepted Solution

by:
arduk earned 500 total points
ID: 34911747
I am not sure exactly what happens when you choose "Manage data sources" - it may try to open the actual data source?
Is it only this data source that this occurs on?
can you right click the datasource, and download it to file, and then change the connection string and upload it again?
Also, check the logs on the sharepoint server for any additional information that may be useful...
0
 

Author Closing Comment

by:dkumeri
ID: 35199607
thanks
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

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

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

688 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