all groups > sql server reporting services > august 2004 >
You're in the

sql server reporting services

group:

All roads lead to '401: Access Denied.' Help!!


All roads lead to '401: Access Denied.' Help!! bill
8/7/2004 5:45:02 PM
sql server reporting services:
Trying to call the Render method from an ASP page.

- Report opens fine with ReportServer Manager
- ReportServer is on the same machine as IIS
- Have set <identity impersonate="true" /> in Web.Config
- Setting Creditials via: rService.Credentials =
System.Net.CredentialCache.DefaultCredentials;
- SQL Server set for MixedMode
- Have tried adding ASPNET user to ReptSvcs (makes no difference)

Get '401: Access Denied' everytime when calling rService.Render()

Any suggestions would be greatly appreciated!


Re: All roads lead to '401: Access Denied.' Help!! Jéjé
8/8/2004 12:41:55 AM
does your website is on the same server as RS?
do you use NT authentication or basic authentication?

if you have 2 servers + NT authentication, then you have delegation
authentication problems.
Make sure your 2 servers are on the same domain.With the active directory,
setup your ASP server to be trusted for delegation.


"bill" <bill@discussions.microsoft.com> a écrit dans le message de
news:2277DF4B-8743-48E5-8B48-ECA497293329@microsoft.com...
[quoted text, click to view]

Re: All roads lead to '401: Access Denied.' Help!! Scott Allen
8/8/2004 9:56:12 AM
Hi bill:

One step I take in debugging issues like this is to enable security
auditing, especially failed logins.

Sometimes in a server environment with impersonation and delegation
and multiple hops I get suprised by the result of who the servers are
actually seeing logging in.

Keith Brown's book has a section on turning on auditing:
http://pluralsight.com/wiki/default.aspx/Keith.GuideBook.HowToEnableAuditing

--
Scott
http://www.OdeToCode.com

On Sat, 7 Aug 2004 17:45:02 -0700, "bill"
[quoted text, click to view]
Re: All roads lead to '401: Access Denied.' Help!! bill
8/8/2004 10:25:01 AM
Thanks Scott. This was very helpful; from seeing the login failures, it looks
like I am fighting a problem with authentication.

I am have a data source that connects to the analysis server. It works great
with Integrated Security, but fails when connection is coming from IUSR_xxxx.

Bill

[quoted text, click to view]
AddThis Social Bookmark Button