Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / New Users / August 2005

Tip: Looking for answers? Try searching our database.

Sql Reporting Serviced - > ASP.NET ACCESS DENIED!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fabian von Romberg - 09 Aug 2005 20:14 GMT
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000
PRO and the other one is WIN 2000 ADV. SERVER.  When I try to access a
report using the webbrowser, I get the following error, this happens only if
try access the report on the SERVER, it I try on my local machine, it works
just fine.  Any help will be much appreciated.

Thanks in advance,
Fabian von Romberg

Server Error in '/Reports' Application.
----------------------------------------------------------------------------
----

Access to the path "C:\Archivos de programa\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path
"C:\Archivos de programa\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.

ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.

Source Error:

     An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[UnauthorizedAccessException: Access to the path "C:\Archivos de
programa\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
denied.]
  System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
  System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String
userPath, Boolean file) +229
  System.IO.Directory.InternalGetDirectories(String path, String userPath,
String searchPattern) +24
  System.IO.Directory.GetDirectories(String path, String searchPattern)
+477

Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
  Microsoft.ReportingServices.Diagnostics.Localization..cctor()

[TypeInitializationException: The type initializer for
"Microsoft.ReportingServices.Diagnostics.Localization" threw an exception.]

Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityL
ist(String[] localeList)
  Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
sender, EventArgs e)

System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.
Execute() +60
  System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
Bruce Barker - 09 Aug 2005 20:50 GMT
if you went to the server and used the browser on the server you would see
it work. if you accessed you dev box from another it would fail. this is the
standard no creditials forwarding issue. set a domain account and password
in the web config.

-- bruce (sqlwork.com)

> Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000
> PRO and the other one is WIN 2000 ADV. SERVER.  When I try to access a
[quoted text clipped - 72 lines]
>   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +87
Fabian von Romberg - 09 Aug 2005 23:14 GMT
Hi Bruce, thanks for your reply.  Actually I get the error "access denied"
using the browser on the same machine (server).  I have read carefully the
whole error message, but ASP.NET account is not listed as a USER. So I have
read this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html
/secmod15.asp to create the account, but still get the error message.

Your help will be appreciated.

Thanks and Regards,
Fabian

> if you went to the server and used the browser on the server you would see
> it work. if you accessed you dev box from another it would fail. this is the
[quoted text clipped - 63 lines]
> >   System.IO.Directory.GetDirectories(String path, String searchPattern)
> > +477

Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
> >   Microsoft.ReportingServices.Diagnostics.Localization..cctor()
> >
> > [TypeInitializationException: The type initializer for
> > "Microsoft.ReportingServices.Diagnostics.Localization" threw an
> > exception.]

Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityL
> > ist(String[] localeList)

Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
> > sender, EventArgs e)

System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.
> > Execute() +60
> >   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > completedSynchronously) +87
Bruce Barker - 10 Aug 2005 01:21 GMT
so did not read the error message close. the error message say that asp.net
does not have access to C:\Archivos de programa\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\bin" directory.

check that it exists, and access is granted.

-- bruce (sqlwork.com)

> Hi Bruce, thanks for your reply.  Actually I get the error "access denied"
> using the browser on the same machine (server).  I have read carefully the
[quoted text clipped - 108 lines]
>> >   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
>> > completedSynchronously) +87
Nick Malik [Microsoft] - 10 Aug 2005 07:23 GMT
Could you have cross-posted on more groups?  Zowie!

Anyway, I just saw this error this evening on another app.

If you access your web app from a browser on the server, then the
credentials of the accessing user will be used, even if Impersonate is set
to true.  Accessing from the client will respect the impersonation options
for ASP.Net.  I'm sure that there is some secret config setting to change
this behavior, and perhaps, someday, I'll stumble on it.  Until then...

The account you are logging in to when on the server doesn't have the
appropriate access.  When accessing from the client, it is using a different
account, one with the appropriate permissions.

Tell me: do you have anonymous access or Windows Authentication?
In the web.config file, do you have <Impersonate> set to True?  Are you
providing an account in the tag?

(I'll guess your answers: Windows auth, Impersonate = True, and you are
providing an account.)  If that is the case, then the account you provided
in the impersonate tag has the correct permissions, but your login account
on the server does not.

Signature

--- Nick Malik [Microsoft]
   MCSD, CFPS, Certified Scrummaster
   http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
  I do not answer questions on behalf of my employer.  I'm just a
programmer helping programmers.
--

> Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000
> PRO and the other one is WIN 2000 ADV. SERVER.  When I try to access a
[quoted text clipped - 72 lines]
>   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +87

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.