• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

FIXED --- MS SQL Reporting Server setup problems - what do I need that I haven't got?

W

Wiz

Diamond Member
I have SQL Server 2005 installed on Win XP Pro sp2 and am trying to get the report server running. This is generally for my own education, the place I work is very much behind me playing with this stuff so I can learn new things and keep up.

I can go into MS VS 2005 & create a report project and make a layout that queries the database and presents data. That's all good.

The trouble comes when I try to run the thing, it seems to say I dont have a reporting server running. When I installed SQL I installed everything, but maybe I missed something?
There's no reporting server service in my services control panel, and when I go to Configure Reporting server it says it can't find one.

Here is the error I am getting, keep in mind I am very green when it comes to running IIS.

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/reportserver.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Failed to access IIS metabase.</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/reportserver' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Failed to access IIS metabase.</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>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.

<br><br>

<b> Exception Details: </b>System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.
<br><br><b>The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see <a href="http://support.microsoft.com/?kbid=267904">http://support.microsoft.com/?kbid=2679...;/a>.</b><br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code>

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.</code>

</td>
</tr>
</table>

<br>

<b>Stack Trace:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[HostingEnvironmentException: Failed to access IIS metabase.]
System.Web.Configuration.MetabaseServerConfig.MapPathCaching(String siteID, VirtualPath path) +3492186
System.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigM
pPath.MapPath(String siteID, VirtualPath vpath) +9
System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +163
System.Web.CachedPathData.GetConfigPathData(String configPath) +382
System.Web.CachedPathData.GetConfigPathData(String configPath) +243
System.Web.CachedPathData.GetApplicationPathData() +68
System.Web.CachedPathData.GetVirtualPathData(VirtualPath virtualPath, Boolean permitPathsOutsideApp) +3385695
System.Web.Configuration.RuntimeConfig.GetLKGRuntimeConfig(VirtualPath path) +189
</pre></code>

</td>
</tr>
</table>

<br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

</font>

</body>
</html>
<!--
[HostingEnvironmentException]: Failed to access IIS metabase.
at System.Web.Configuration.MetabaseServerConfig.MapPathCaching(String siteID, VirtualPath path)
at System.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigM
pPath.MapPath(StringSystem.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigM
pPath.MapPath(String siteID, VirtualPath vpath)
at System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull)
at System.Web.CachedPathData.GetConfigPathData(String configPath)
at System.Web.CachedPathData.GetConfigPathData(String configPath)
at System.Web.CachedPathData.GetApplicationPathData()
at System.Web.CachedPathData.GetVirtualPathData(VirtualPath virtualPath, Boolean permitPathsOutsideApp)
at System.Web.Configuration.RuntimeConfig.GetLKGRuntimeConfig(VirtualPath path)
-->
--. (Microsoft.ReportingServices.Designer)

------------------------------
BUTTONS:

OK
------------------------------
Click to expand...



"Help me, Obi-Wan Kenobi; you're my only hope."

http://www.imdb.com/title/tt0076759/quotes
 
It looks like your problem has to do with permissions.. either with the ASP.NET worker process or report services.

cut and paste from above:
The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see...
 
What account is running the Application Pool that the Report Server Virtual directory is running on? This is found on the Identity tab of an Application Pool in IIS.
 
What account is running the Application Pool that the Report Server Virtual directory is running on? This is found on the Identity tab of an Application Pool in IIS.
Click to expand...


It has IIS 5 and I don't see what you are talking about. I am looking at IIS CPL here - looks like:

- (local computer)
- Web Sites
... -Default Web Site
... ... + IISHelp
... ... reportserver (a virtual dir I set up manually)

I can right click & get properties etc, set which asp.net (1.1 or 2.0) get some settings for these...
 
oops, looks like the Installer didn't give me all the options the first time - just re-ran install & found Reporting Services & installed it.
 
Thanks!

It's installed but am still geting errors - at least different errors now:

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/reportserver.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>
<p>
<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span></p>
<p>
<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
</p>
</body>
</html>

--. (Microsoft.ReportingServices.Designer)

------------------------------
BUTTONS:

OK
------------------------------
Click to expand...

In the error log I get this:

aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account has insufficient rights to read the .NET Framework files. Please ensure that the .NET Framework is correctly installed and that the ACLs on the installation directory allow access to the configured account.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Click to expand...

 
I am no help but are you running that under an admin account and have you set up the permission rights the software needs. see told you I wasn't any help🙁
 
Thanks again, I don't really know - it would be nice if this stuff would either build the accounts it needs when installing or tell you what accounts you have to manually set up.
 
Hey Wiz,

I put a link up to some step by step install procedures for SSRS on the TE forums. Let me know if that doesn't get you further and I will take a closer look at the errors.
 
I just got it running, I searched the errors on google and found some good stuff on an sql forum - someone suggested editing one of the config files to add the url of the reportserver because it does not get automatically populated. I did that and restarted the machine, then guess what? It worked! 😉
 
Here's a weird thing.

When I tried loading the Home page for reports it said I had an invalid element in my config file. I removed what I had added to get the thing working (the URL) and then everything worked.

Maybe I was confused about why it started working yesterday, maybe it was that I finally got the permissions & accounts set up right.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top