Solved

SSRS sharepoint

Posted on 2011-02-16
6
935 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now