473,320 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Sql Reporting Serviced - > ASP.NET ACCESS DENIED!

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.Localizati on.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localizati on..cctor()

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

Microsoft.ReportingServices.Diagnostics.Localizati on.SetCultureFromPriorityL
ist(String[] localeList)
Microsoft.ReportingServices.UI.GlobalApp.Applicati on_BeginRequest(Object
sender, EventArgs e)

System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep.
Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +87


Aug 9 '05 #1
4 3862
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)
"Fabian von Romberg" <fr*********@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...
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.Localizati on.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localizati on..cctor()

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

Microsoft.ReportingServices.Diagnostics.Localizati on.SetCultureFromPriorityL
ist(String[] localeList)
Microsoft.ReportingServices.UI.GlobalApp.Applicati on_BeginRequest(Object
sender, EventArgs e)

System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep.
Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +87

Aug 9 '05 #2
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/de...us/secmod/html
/secmod15.asp to create the account, but still get the error message.

Your help will be appreciated.

Thanks and Regards,
Fabian
"Bruce Barker" <br******************@safeco.com> wrote in message
news:ef**************@TK2MSFTNGP12.phx.gbl...
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)
"Fabian von Romberg" <fr*********@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...
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.Localizati on.GetInstalledCultures() Microsoft.ReportingServices.Diagnostics.Localizati on..cctor()

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

Microsoft.ReportingServices.Diagnostics.Localizati on.SetCultureFromPriorityL ist(String[] localeList)
Microsoft.ReportingServices.UI.GlobalApp.Applicati on_BeginRequest(Object sender, EventArgs e)

System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep. Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +87


Aug 9 '05 #3
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)

"Fabian von Romberg" <fr*********@hotmail.com> wrote in message
news:ON**************@TK2MSFTNGP09.phx.gbl...
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/de...us/secmod/html
/secmod15.asp to create the account, but still get the error message.

Your help will be appreciated.

Thanks and Regards,
Fabian
"Bruce Barker" <br******************@safeco.com> wrote in message
news:ef**************@TK2MSFTNGP12.phx.gbl...
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)
"Fabian von Romberg" <fr*********@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...
> 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.Localizati on.GetInstalledCultures() > Microsoft.ReportingServices.Diagnostics.Localizati on..cctor()
>
> [TypeInitializationException: The type initializer for
> "Microsoft.ReportingServices.Diagnostics.Localizat ion" threw an
> exception.]
>
> Microsoft.ReportingServices.Diagnostics.Localizati on.SetCultureFromPriorityL > ist(String[] localeList)
> Microsoft.ReportingServices.UI.GlobalApp.Applicati on_BeginRequest(Object > sender, EventArgs e)
>
> System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep. > Execute() +60
> System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
> completedSynchronously) +87
>
>
>
>



Aug 10 '05 #4
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.

--
--- 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.
--
"Fabian von Romberg" <fr*********@hotmail.com> wrote in message
news:Op**************@TK2MSFTNGP09.phx.gbl...
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.Localizati on.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localizati on..cctor()

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

Microsoft.ReportingServices.Diagnostics.Localizati on.SetCultureFromPriorityL
ist(String[] localeList)
Microsoft.ReportingServices.UI.GlobalApp.Applicati on_BeginRequest(Object
sender, EventArgs e)

System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep.
Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +87

Aug 10 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Stan | last post by:
Here is my scenario: Web server ------------ Framework 1.1 Application proxy for the serviced component Component server ------------------- Framework 1.0
0
by: Oliver | last post by:
hi - I have a written a "Serviced Component" which works fine when declared as: but I am seeing an 'Access Denied' exception when I declare it as: this is probably something to do with...
0
by: Oliver | last post by:
> I am seeing an 'Access Denied' exception when using a "Server" "Serviced Component" >> ..are...registered in the GAC ? yes. >> ..are...the parameters serializable? um - parameters? - the...
0
by: Ed S | last post by:
I have an ASP.NET application running and am trying to get the module information for this process (the aspnet_wp.exe process I assume) The call to System.Diagnostics.Process.get_Modules() is...
7
by: Martin Strojek | last post by:
Hi, I have the following problem with developing some web site. I use Visual Studio 2003 to build a website. I tried Windows 2003 Server and switched now back to Windows XP with PWS but the...
4
by: Fabian von Romberg | last post by:
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...
1
by: markeboy | last post by:
I want to be able to call a web service using integrated windows authentication from a serviced component? The COM+ application is configured to use a domain account, however, I get an access...
0
by: =?Utf-8?B?Sm9uYXRoYW4=?= | last post by:
Hi, we have a number of clients that range from corporates to single users. Currently our applications are written in MS Access. However the corporates are requesting that we migrate to dot Net and...
0
by: bharathreddy | last post by:
In .Net COM+ components are referred to as serviced components, Namespace: System.EnterpriseServices; Advantage of Serviced Components: object pooling, database connection pooling,
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.