Solved

SSRS with SharePoint 2010 HTTP status 401: Unauthorized.

Posted on 2011-03-15
4
1,406 Views
Last Modified: 2012-05-11
hi experts,

i have the following:

sp2010-App(sharepoint 2010 enterprise)
sp2010-SQL(Microsoft SQL Server 2008 R2)
sp2010-SSRS(Microsoft SQL Server 2008 R2 SSRS)

i configer SSRS with sharepoint, so all reports works fine from sp2010-APP server only!!!

when i browse from another server in domain or as clint, error message coming:

The request failed with HTTP status 401: Unauthorized

NB:
IIS Authentication on sharepoint Settings is NTLM
on central administration the Authentication Mode on  Reporting Services Integration is windows authintication
rsreportserver.cofig on SSRS setting :
      <Authentication>
            <AuthenticationTypes>
                  <RSWindowsNTLM />
            </AuthenticationTypes>
            <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
            <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
            <EnableAuthPersistence>true</EnableAuthPersistence>
      </Authentication>
0
Comment
Question by:abjod
  • 2
4 Comments
 
LVL 32

Expert Comment

by:it_saige
Comment Utility
Try enabling Kernel Mode Authentication on your Sharepoint site.

http://blog.michelbarneveld.nl/michel/archive/2009/11/16/sharepoint-2010-and-kernel-mode-authentication.aspx

And then configure your Sharepoint Services to use NTLM.

http://technet.microsoft.com/en-us/library/gg266385.aspx

-saige-
0
 
LVL 5

Expert Comment

by:navdeepmadan
Comment Utility
1) please check the ULS logs and event viewer logs and check errors.
2) Check  the IIS logs and check for the errors. It's looks like a premission issue.
3) after this you will come to which user requires access on which site.
0
 

Accepted Solution

by:
abjod earned 0 total points
Comment Utility
please review this file to solve any issue for sp with ssrs
SSRSKerberos.docx
0
 

Author Closing Comment

by:abjod
Comment Utility
i now understand authentication process between sp & ssrs
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

728 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

10 Experts available now in Live!

Get 1:1 Help Now