Cant connect to Report Services (Network Steve Forum)

Cant connect to Report Services

Hello I just installed SQL Server 2005 Developer on my pc. but I cant connect to it and I'm not sure why I used all the default options and I dont have a password on it. This is the message I'm getting Can anyone help please TITLE: Connect to Server ------------------------------ Cannot connect to DESIREE-3B615B5. ------------------------------ 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=267904</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) +637 System.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigMapPath2.MapPath(String siteID, VirtualPath vpath) +9 System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +174 System.Web.Hosting.HostingEnvironment.MapPathInternal(VirtualPath virtualPath, Boolean permitNull) +51 System.Web.CachedPathData.GetConfigPathData(String configPath) +341 System.Web.CachedPathData.GetConfigPathData(String configPath) +234 System.Web.CachedPathData.GetApplicationPathData() +38 System.Web.CachedPathData.GetVirtualPathData(VirtualPath virtualPath, Boolean permitPathsOutsideApp) +8809871 System.Web.Configuration.RuntimeConfig.GetLKGRuntimeConfig(VirtualPath path) +117 </pre></code> </td> </tr> </table> <br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.3620; ASP.NET Version:2.0.50727.3618 </font> </body> </html>  --. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------

May 5th, 2011 2:02am

Is SSRS service running up? Go to configurations tools and choose Reporting Service configuration option Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Free Windows Admin Tool Kit Click here and download it now

May 5th, 2011 2:58am

Hello Uri Dimant yes its running I checked it Reporting Services Configuration

May 5th, 2011 6:07am

Enter the server name manualy and try to connect...if its not showing reporting server selection list..-------------------------------------------------------------------------------- Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.

Free Windows Admin Tool Kit Click here and download it now

May 5th, 2011 8:53am

Hi desireemm1, As the error message shows, the process account used to run ASP.NET must have read access to the IIS metabase. So, what’s your ASP.NET account? You can check this by opening the Reporting Services Configuration Manager, and then select "Web Service Identity" tab. In order to modify metabase permissions, please try to use the Metaacl tool. For more information, please refer to http://support.microsoft.com/?kbid=267904 Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

May 10th, 2011 3:02am

This topic is archived. No further replies will be accepted.