Can not connect to ReportServer. HTTP 404 - File not found

Question

I am running SQL Server 2008 Express.

I notice it did not create the reportserver directory in the Default Web Site.  I read one solution that said to go in Reporting Services Configuration Manager and click on the New button.  I can not find the New button.

I think the original problem was my IIS server was not working right so I reinstalled it.  It is working now.  How do I get Reporting Services to recreate the directories?

Thanks for any help,

Fred

Answer 1

Starting with SQL Server 2008, you don´t need an IIS anymore to host SQL Server Reporting Services. It uses a http.sys driver to handle requests. Make sure that that the  guideline you are using is acually talking about SQL Server 2008.

-Jens

---

Jens K. Suessmeyer http://blogs.msdn.com/Jenss

Answer 2

Thanks for the response.

What is the URL for the Report Manager?  I have tried several possibilities but so far not the right one.

Fred

Answer 3

That depends what you configured in the Reporting Service configuration manager.

-Jens

---

Jens K. Suessmeyer http://blogs.msdn.com/Jenss

Answer 4

I am using the default URLs.  The Web Service URL Virtual Directory is ReportServer and the Report Manager URL Virtual Directory is Reports.  When I try to connect to http://localhost/reportserver or http://localhost/reports I get the error message: 

The page cannot be found

HTTP 404 - File not found

I have to start Reporting Services Configuration Manager and start the Report Server.   There are no error messages in starting it so it looks like it is running.

In BIDS I can run the reports but I cannot deploy them because it cannot find the directory.

IIS is running and when I connect to http://localhost it opens up the localstart.asp with no errors.

What do I check next?

Fred

Answer 5

I am having the same problem. SQL Server 2008 and SSRS are installed properly on Windows Server 2008. Report Configuration is geting open. Problem is the report manager and reports are not opening from browser. It is giving me page not found error. Also Reporting Services I am not able to connect in database, using Management Studio.
I have tried  following solutions:
1. Trusted site option in IE
2. Automatic Logon option of IE.
3. Friendly user messge ive uncheck from IE
4. Instead of localsytem network service account option to login to SRS
5. Creating virtual directory in IIS for givng permissions. (though SSRS 2008 is not dependent on IIS)

Now last thing i want to try is giving roles and access from database security. But unable to do so as not able to connect reporting services through database. It is giving following error.
unable to connect to the server. The specified URL might not be valid or there might be problem with the report server version or configuration. Specify a different URL or Contact your server administrator to verify that the report server runs SQL SERVER 2008 or later.

PLZ HELP, ITS VERY URGENT. This is the scenario of production server.

In addition let me tell you all SSRS 2008 working on Windows Vista perfectly on my development server.

Regards,
Prajakti

Answer 6

Pls how did you resolve it

Answer 7

Just as said before SQL Server 2008 does not need IIS, you only need to know how it is configured on your machine

1- SQL Server 2008 > Configuration Tools > Reporting Service Configuration Manager

2- Under Web Service URL > Configure the service URL as you want but most importantly is to change the port from 80 (default for web server) to any free port such as 8080 > Apply changes and check the URL given to you

3- Under Report Manager URL > Click Advanced > Change the port to what you configured in previous step > Apply changes and check


Thank you

Answer 8

Just as said before SQL Server 2008 does not need IIS, you only need to know how it is configured on your machine

1- SQL Server 2008 > Configuration Tools > Reporting Service Configuration Manager

2- Under Web Service URL > Configure the service URL as you want but most importantly is to change the port from 80 (default for web server) to any free port such as 8080 > Apply changes and check the URL given to you

3- Under Report Manager URL > Click Advanced > Change the port to what you configured in previous step > Apply changes and check


Thank you

I think the the sql server team assume that it is in any case not a good pratice to have an iis installed on the same machine that sql server runs. That's why they put port 80 as default. Or is it simply a bad default?

Answer 9

Just as said before SQL Server 2008 does not need IIS, you only need to know how it is configured on your machine

1- SQL Server 2008 > Configuration Tools > Reporting Service Configuration Manager

2- Under Web Service URL > Configure the service URL as you want but most importantly is to change the port from 80 (default for web server) to any free port such as 8080 > Apply changes and check the URL given to you

3- Under Report Manager URL > Click Advanced > Change the port to what you configured in previous step > Apply changes and check


Thank you

I think the the sql server team assume that it is in any case not a good pratice to have an iis installed on the same machine that sql server runs. That's why they put port 80 as default. Or is it simply a bad default?

Realy I don't know the actual reason for that but i do not think that they would lose if they just used any other free port

Answer 10

Just as said before SQL Server 2008 does not need IIS, you only need to know how it is configured on your machine

1- SQL Server 2008 > Configuration Tools > Reporting Service Configuration Manager

2- Under Web Service URL > Configure the service URL as you want but most importantly is to change the port from 80 (default for web server) to any free port such as 8080 > Apply changes and check the URL given to you

3- Under Report Manager URL > Click Advanced > Change the port to what you configured in previous step > Apply changes and check


Thank you

Thank you for the help.  It's still valuable many months later.  Mike Lupro - BestTechsNW

Answer 11

Just as said before SQL Server 2008 does not need IIS, you only need to know how it is configured on your machine

1- SQL Server 2008 > Configuration Tools > Reporting Service Configuration Manager

2- Under Web Service URL > Configure the service URL as you want but most importantly is to change the port from 80 (default for web server) to any free port such as 8080 > Apply changes and check the URL given to you

3- Under Report Manager URL > Click Advanced > Change the port to what you configured in previous step > Apply changes and check


Thank you

Thank You.

Answer 12

I had an issue with the report manager url returning 404 when only using the HTTP link. The HTTPS link worked just fine. Here's what I found.

I was able to solve my issue of the Report Manager URL not working when using HTTP, but working using HTTPS. A netmon trace revealed that an HTTP 302 redirect request to the HTTPS page. I modified the rsreportserver.config file to update this line:

 <Add Key="SecureConnectionLevel" Value="0"/>

The original value was set to 2.

Here is a great post on the different values and a better explanation of the underlying issue:

http://blog.hoegaerden.be/2009/05/24/reporting-services-2008-and-ssl/

---

---

Jason Ogle MCITP Enterprise Administrator

Answer 13

I know this is an old thread but after some serching seems to come closest to my problem...I have sql server express 2012 installed, and I'm able to get into the management studio and query a local machine database I created, no problems.

But when I go to change the connection to connect object explorer and change the dropdown to server type>Reporting Services (currently set at Database Engine), it gives me the "specified URL might not be valid" error.

I've tried starting the SQL Server Reporting Services (SQLEXPRESS) service manually, but it says "service did not start due to a logon failure".

I then tried following the steps above describing going into the Configuration Tools>Reporting Services Configuration Manager.  On the left I see my local instance, underneath it Service Account, Web Service URL, etc. But Web Service URL and all entries under it (Database, Report Manager URL) are greyed out and unclickable.

Kinda got thrown into learning this stuff on my own, any help getting me connected would be greatly appreciated.

PS I use the Windows Authentication method to access the DB, no separate username/password.

Answer 14

I managed to fix it...for anyone else having the issue:  The items in the Configuration Tools>Reporting Services Configuration manager were greyed out until I manually entered my username/password.  It looked like it was set to use Windows Authentication just like the SQL server management studio, but putting the info in manually by selecting the second radio button got me through.  

After that, I changed the port to 8080 as above and now I'm in.

Answer 15

If you change the port and it works, most likely something else is using port 80. Using netstat(netstat -o -n -a | findstr 0.0:80) and looking at the PID in services under task manager, i figured out for me it was a brocade service that got installed and wasn't needed.