Sunday, February 19, 2012

Error Starting Reporting Services in SQL Server 2005

Hi ,

I am trying to connect to Reporting Services through SSMS using the following parameters:

Server_Type: Reporting Services

Server Name : <Server_Name>

Authentication: Windows Authentication

Got the following error message:


TITLE: Connect to Server

Cannot connect to <Server_Name>


ADDITIONAL INFORMATION:

Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<html><head><title>Server Application Error</title></head>
<body>
<h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request.
Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html>
--. (Microsoft.SqlServer.Management.UI.RSClient)

Any help would be deeply appreciated,

Thanks a lot for your Time,

Regards,

Sundar

Hi,

Can you please post any relevant Event Log entries from the Application Tier server (the one on which TFS, SharePoint and SQL Server Reporting Services reside)? Please also examine the IIS log for any suspicious error messages and if you find any, please post them here.

|||

Hi,

In the Event Viewer Log, I got the following message :

The server failed to load application '/LM/W3SVC'. The error was 'The specified metadata was not found.

'.

For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.

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

does this metadata have to do anything with text/xml format ?

Thanks in Advance for your Help,

Regards,

Sundar

|||

Hi,

It looks like your IIS metabase somehow got corrupted The metabase is indeed stored in XML format, you can find extensive info on the metabase here:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/6929e089-c495-4ac8-8db0-b069b349b7ba.mspx?mfr=true

"/LM/W3SVC" metabase entry corresponds to the WWW service:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/44a57859-8fbb-4238-a7b5-f10c34cf8fe8.mspx?mfr=true

Since IIS reports it can't load the metadata for the WWW service itself, you will most likely have to reinstall the IIS and everything on top of IIS (Windows SharePoint Services, TFS application tier, SQL Server Reporting Services and anything else that is hosted in IIS). Before doing that, though, consider posting your question in the IIS community, I hope someone will be able to assist you in fixing your metabase given the corruption is not fatal. If you have support incidents available, consider also contacting Microsoft Support and be sure to provide them with the maximum details of what happened before you started getting this nasty error message.

I apologize for not being more helpful - I am by no means an IIS expert. Hope the info above helps you to define the further direction of your support quest and good luck!

|||

Thanks for your reply,Buddy.

Will check with the IIS folks.

Regards,

Sundar

|||

Hi,

I re-installed IIS and then removed and re-installed .Net Framework 2.0 ..

Things finally worked my way !!

Thanks a lot for all your help !!

Regards,

Sundar

No comments:

Post a Comment