SSRS Report Manager giving error please help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SSRS Report Manager giving error please help

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2009-05-01 : 07:01:59

Hi,
We have a clustered Sql server 2005 and IIS server.
we needed to deploy sql 2005 reporting services.
i installed SSRS and completed all the steps successfully from reporting services configuration manager
now when i try to open http://localhost/reports/ i get bad request error
when i directly open the default page specified in reports virtual directory , i get following error
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
A name was started with an invalid character. Error processing resource "

I have tried folowing steps
1. checked .Net version of the virtual directories created, it is 2.0.50727, i have .net 2.0 version installed on local system, so .Net version doesn't seems to be the issues here
2. Deleted and recreated virtual directories
3. ran "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i"

Please help

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-05-01 : 07:41:47

quote:
Originally posted by rajkumarrai_bis

Hi,
We have a clustered Sql server 2005 and IIS server.
we needed to deploy sql 2005 reporting services.
i installed SSRS and completed all the steps successfully from reporting services configuration manager
now when i try to open http://localhost/reports/ i get bad request error
when i directly open the default page specified in reports virtual directory , i get following error
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
A name was started with an invalid character. Error processing resource "

I have tried folowing steps
1. checked .Net version of the virtual directories created, it is 2.0.50727, i have .net 2.0 version installed on local system, so .Net version doesn't seems to be the issues here
2. Deleted and recreated virtual directories
3. ran "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i"

Please help

did u chk event logs and sql logs

Regards,
Ahmad Osama

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2009-05-06 : 08:23:41

Hi Ahmad,
thanks for the help.
yes i did checked the event logs and sql logs but couldn't find anything useful.
but there is some good news,this problem is resolved :)
the problem was that default website was set to listen on some specific IP along with host file entry for localhost 127.0.0.1
now since SSRS virtual directories gets created under default website so browser was not able to host them.
setting default website to all unassigned ipaddress solved the problem

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources