March 19, 2012 at 11:37 am
I am trying to prepare a Win2K 2003 server edition as Reporting Server for 2005 SQL Server.
throws this error:
"The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead."
Some sites suggested changing the RSWebApplication.config to remove localhost.
and then I get this error.
"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version."
The Report Server seems to be behaving okay although shows only this bit on the page:
localhost/ReportServer - /
--------------------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 9.00.1406.00
The current RSWebApplication.config file contains this:
<Configuration>
<UI>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
I have tried many things so far and have checked google thousand times so far for any possible one solution that can work.
Can someone guide me please to get this thing working?
Thanks,
Bij
March 19, 2012 at 12:18 pm
Confirm the following checks from your side:
1. Reportserver & ReportServerTempDB databases are present in the instance
2. All configurations have been done and error free in Reporting Services Configuration Manager
3. Open and confirm settings in rsreportserver.config
Some support documentation:
http://msdn.microsoft.com/en-us/library/ms157273.aspx
http://msdn.microsoft.com/en-us/library/ms157273(v=sql.90).aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 20, 2012 at 4:35 am
Thanks for the Reply.
I checked everything again. Both the databases are there. I could manage to deploy a report as well from localhost/reportserver.
But localhost/reports still won't work.
From rsreportserver.config I removed URLroot, changed it to IPaddress, hostname and back to localhost, but nothing works!
Here is the output on the webpage.
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead.
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.Exception: The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead.
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:
[Exception: The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead.]
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1209
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +1017
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +48
[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +171
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +67
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +294
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +121
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +102
Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3625; ASP.NET Version:2.0.50727.3618
Any other clue?
Bij
March 27, 2012 at 5:05 am
i would re-run the config manager and see what that does. I dont have SSRS 2005 as we are fully 2008 and the config shows http://+:80 for both my reports and reportserver URL's but unsure if this will be correct for 2005
March 27, 2012 at 5:48 am
Thanks Anthony.
I re-ran the Config Manager and upto the point of Initialisation everything is fine. The tick is there on Initialisation. Reports themselves do work on localhost/reportserver, but it's the localhost/reports that failing.
I changed the localhost to servername and no difference.
Reporting Services 2008 config files are different to 2005. We also have 1 virtual server of SQL 2008, but I can't use that.
The reason I cross-posted in other Topic headers, is because I didn't see a Reporting Services heading before and this was the closest I could think of putting in.
Then I thought this heading may not attract more viewers and hence no one to reply.
I am happy for the Admin to move this to the Reporting Admin Section if it helps.
Thanks
Bij
March 27, 2012 at 5:52 am
Did you tried by adding host entry?
March 27, 2012 at 7:19 am
Host entry as in \etc\hosts? I tried that as well, with localhost mapped to <servername>
Also in IIS added both localhost and servername to the Default Website.
Recycled the Application Pool and restarted IIS too. and the Server as well.
Just don't know what else could I do.
Bij
March 27, 2012 at 7:22 am
i know this is a bit extreme but have you uninstalled and reinstalled SSRS?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply