Solved

SSRS sharepoint

Posted on 2011-02-16
6
973 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

807 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