?
Solved

SSRS sharepoint

Posted on 2011-02-16
6
Medium Priority
?
1,001 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
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.

 

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 1500 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

801 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