I'm trying to configure an instance of SSRS, but with little success.
I've installed SSRS on the server DWHFRONT. It runs under the Network Service credentials. On the Database tab of the Reporting Services Configuration Manager, I've set it up to use a database on DWHBACK, which it created succesfully. The connection uses a domain account DOM\SA_DWH. I've added a Login to the server DWHBACK for DOM\SA_DWH, and I can see that the Reporting Services Manager added the authorisations to the SSRS-databases. The Configuration Manager accepts these connection parameters.
However (after setting up the URLs, Virtual Directories etc) if I visit the URL of DWHFRONT/Reports/, I get an error saying:
The service is not available.
The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database because it doesn’t have permission to do so. Use Reporting Services Configuration Manager to update the report server database credentials.
At first I thought it might be an issue because there is noting deployed to the SSRS instance yet. When I try to deploy something however, I get this error in BIDS:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (Microsoft.ReportingServices.Designer)
Thanks for all the suggestions, It put me on the right track!
The Domain Account SA_DWH was prohibited from interactive logon. SSRS apparently does require this. The Interactive Logon restriction was lifted and now it works.