I am trying to setup reporting services on a SQL server 2008 and get this error message when I try to connect to the http://localhost/reports
The request failed with HTTP status 401: Unauthorized.
- I asked the server administrator and the IIS should be running (can't find it under administrative tools though)
- I used the Reporting Services Configuration manager to setup reporting services and am pretty sure it is setup correct.
Best Answer
In Report Services 2008 by default it uses its own built-in server, not IIS. You'll need to check in the reporting services directory on your server (its in the usual MSSQL directory in Program Files) to see the configuration files and make changes (you can also make some through reporting services configuration manager). Microsoft does not recommend installing IIS on the reporting services server.