August 1, 2010 at 11:53 pm
Hi all,
I have recently installed SQL Server 2008 Reporting Service but unable to connect to report manager. I got the following error:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
This error occurred while connect to: http://<servername>/reports
but when I use http://<server name>/reportserver, it will show SYS1 and Users Folders.
Any idea will be greatly appreciated.
Sani.
August 2, 2010 at 1:01 am
Check ur reporting server configuration..
Check u have the same version of reporting server installed..
August 2, 2010 at 1:23 am
At first I have installed SQL Server 2005 Reporting Service and Engine but as We need to have latest version, I have uninstalled it and installed SQL Server 2008 Reporting Service and Engine.
Do you think this the root cause of the problem?
Thanks for the reply.
Sani.
August 2, 2010 at 2:04 am
If both same version then there wont be any issue..check the report server name..New installation might have installed under different name ..not sure..
August 2, 2010 at 2:46 am
Database engine and Reporting service has the same version. I used the same name for installation.
Sani.
August 2, 2010 at 3:09 am
Edit the file RSWebApplication.config under C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager and add the full url to the ReportServer into the ReportServerUrl tag.AND remove the value from ReportServerVirtualDirectory. You must recycle the application pool used by the Report-Manager so that config file is being reloaded.
August 2, 2010 at 3:21 am
RSWebApplication.config's content in SQL Server 2008 Reporting Service is as follows:
<Configuration>
<!-- This configuration file is obsolete. Its content has been merged into rsreportserver.config -->
</Configuration>
I have added the URL in rsreportserver.config as follows but I got the same error
<UI>
<ReportServerUrl>
http://<server name>/reports
</ReportServerUrl>
<PageCountMode>Estimate</PageCountMode>
</UI>
<UrlRoot>http://<server name>/reports</UrlRoot>.
Sani.
August 2, 2010 at 4:39 am
add the localhost hostheader to the web-site which hosts the /reportserver/ and try
August 2, 2010 at 4:46 am
I did but no use
August 2, 2010 at 5:18 am
U getting the same Error or??
August 2, 2010 at 9:43 pm
I got HTTP error (400). bad request
August 2, 2010 at 10:42 pm
this might help
http://www.sqlservercentral.com/Forums/Topic235765-150-1.aspx
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply