Monday, February 20, 2012

Reporting Services, Sharepoint and MOM on Windows Server 2003

Hello,
I have just installed the SQL Server 2000 Reporting Services on the Windows
Server 2003 (non-DC).
My machine already has MOM 2005 Evaluation and the Sharepoint services
installed. I followed and did all the necessary changes written out in the
setup documentation in order for RS to live with Sharepoint.
Installation of RS with all the default options went fine, however neither
http://localhost/ReportServer nor http://localhost/Reports runs normally.
1) The ReportServer only gives me the lines:
localhost/ReportServer - /
----
----
Microsoft SQL Server Reporting Services Version 8.00.743.00
2) And the Report Manager gives me:
Server Error in '/Reports' Application.
----
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" 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:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" 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:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\global.asax" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, Boolean
bFromProxy) +888
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize) +44
System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean
detectEncodingFromByteOrderMarks, Int32 bufferSize) +79
System.Web.UI.Util.ReaderFromFile(String filename, HttpContext context,
String configPath) +443
System.Web.UI.TemplateParser.ParseFile(String filename, String
virtualPath) +62
System.Web.UI.TemplateParser.Parse() +200
System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() +74
System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean
fCreateIfNotFound) +189
System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() +125
System.Web.UI.TemplateParser.GetParserCacheItem() +87
System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String
inputFile, HttpContext context, ApplicationFileParser& parser) +171
System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
+43
System.Web.HttpApplicationFactory.Init(HttpContext context) +485
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +170
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
What's wrong?
MantvydasSeems to have solved it myself. I just messed with the Application Pools
most probably.
I have put the Reports Virtual Directory to MSSharePointAppPool and
everything came to normal.
Mantvydas
"Mantvis" <mantvydas at delfi dot lt> wrote in message
news:u7cewq7rEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have just installed the SQL Server 2000 Reporting Services on the
> Windows Server 2003 (non-DC).
> My machine already has MOM 2005 Evaluation and the Sharepoint services
> installed. I followed and did all the necessary changes written out in the
> setup documentation in order for RS to live with Sharepoint.
> Installation of RS with all the default options went fine, however neither
> http://localhost/ReportServer nor http://localhost/Reports runs normally.
> 1) The ReportServer only gives me the lines:
> localhost/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 8.00.743.00
> 2) And the Report Manager gives me:
> Server Error in '/Reports' Application.
> ----
> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\global.asax" 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:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\global.asax" 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:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\global.asax" is denied.]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
> System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
> access, FileShare share, Int32 bufferSize, Boolean useAsync, String
> msgPath, Boolean bFromProxy) +888
> System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
> access, FileShare share, Int32 bufferSize) +44
> System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean
> detectEncodingFromByteOrderMarks, Int32 bufferSize) +79
> System.Web.UI.Util.ReaderFromFile(String filename, HttpContext context,
> String configPath) +443
> System.Web.UI.TemplateParser.ParseFile(String filename, String
> virtualPath) +62
> System.Web.UI.TemplateParser.Parse() +200
> System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() +74
> System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean
> fCreateIfNotFound) +189
> System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() +125
> System.Web.UI.TemplateParser.GetParserCacheItem() +87
> System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String
> inputFile, HttpContext context, ApplicationFileParser& parser) +171
> System.Web.HttpApplicationFactory.CompileApplication(HttpContext
> context) +43
> System.Web.HttpApplicationFactory.Init(HttpContext context) +485
> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
> context) +170
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
>
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> What's wrong?
> Mantvydas
>

No comments:

Post a Comment