Friday, February 24, 2012

Can an ASP.NET application running on WinXP+IIS5 access to SSRS web service?

Hi,
I am developing a web application on windows XP. A page within my
application needs to access to SSRS running on the same machine. Once the
web application tries to consume the SSRS web services, I receive the
following error:
System.Web.Services.Protocols.SoapException: The permissions granted to user
DEV1\ASPNET' are insufficient for performing this operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'ALISGD\ASPNET' are insufficient for performing
this operation.
The user DEV1\ASPNET is member of
"SQLServer2005ReportingServicesWebServiceUser$DEV1" local NT groups. Also I
added the user "DEV1\ASPNET" to browsers and also "System Administrator"
role within SSRS web portal. still the same problem.
I do have the following code on my web service proxy code:
reportingService.UseDefaultCredentials = true;
Obviously I can solve the problem by using this code:
System.Net.ICredentials netCredential = new
System.Net.NetworkCredential("Username","Password","Domain");
reportingService.Credentials = netCredential;
But I like to find the root of the problem and solve it properly.
Is there any way that a web application running on IIS5+XP as user "ASPNET'
access to SSRS web service?
Any help would be appreciated,
MaxHello Max,
Please check the following settings:
1. Make sure the ASPNET account is under the RSExec Role in MASTER, MSDB,
ReportServer, ReportTempDB database.
2. Go to Local Policy. For "Act as part of Operating System", added ASPNET
and SYSTEM. For "Impersonate a client after authentication", added SYSTEM.
3. Restarted IIS and RS.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
I have users who don't have "Act as part of Operating System", and they can
work with SSRS web services.
"Act as part of Operating System" works, but I expect there is less
previlage setting for ASPNET user that can intercat with SSRS.
Kind Regards,
Max
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NR0QuNn0HHA.4844@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Max,
I would like to know what permission your other user have.
If you don't grant the "Act as part of Operating System", did this issue
appeared?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment