SSRS Error 2: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

After configuring the Reporting Services (SSRS 2005), I tried to access the Report url http://localhost/reports and I have got an error saying “The ReportServerVirtualDirectory element is missing” then I fixed the issue you can check the steps in my previous post. After resolving this issue,  I  could access the ReportManager page but with the following error:

This means that I have configured the Reporting Server but cannot be reachable via http://localhost/ and I tried in several ways to fix this issue and finally end-up with the following solution:

Step 1: Open the “RSWebApplication.config” file in a Notepad or any other editor. (Normally it is located “C:\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\Reports” but for me under “D:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager”)

Step 2: Check whether <ReportServerUrl> and <ReportServerVirtualDirectory> elements having any values.

Step 3: If  <ReportServerUrl> tag’s element is empty then add the full url of the ReportServer (Not Reports).

Please note: I have tried with server IP, Server Name and localhost, all are working fine for me and if you want to use server name and it ‘s using different port number other than 80, then the ReportServerUrl should be: http://servername:portnumber/ReportServer.

Step 4: If  <ReportServerVirtualDirectory>  tag’s element has any value (for me ReportServer is there, which was added to fix the previous error) then just delete it and leave it empty.

Step 5: Recycle the ReportServer’s App-Pool to reload the “RSWebApplication.config” file. (Just go to the IIS –> Application Pool and click the Recycling on the right hand panel)

That’s all, hope you would get the following page! 🙂

References:

1. http://social.msdn.microsoft.com/Forums/en-HK/sqlreportingservices/thread/530ed56d-7c84-4d13-8998-80a8bf142197

2. http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/0afd896c-8957-4ec1-b9db-5b4e62eccbc0/

Advertisement

, , , , , ,

  1. #1 by Marshall on June 4, 2013 - 2:00 am

    Hi there, just wanted to say, I loved this article. It was helpful.
    Keep on posting!

  1. Fix Snoop Error 2(server Fail) Windows XP, Vista, 7, 8 [Solved]

Please leave a reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: