Getting The report server cannot open a connection to the report server database error

Hi

I went to my comp ->rt cick->manage-IIS->default website->rt click->properties->directory security->annoymouse access…EDIT->under Default domain it was blank, and i added a domain there.

And i was getting error opening up the reports from localhost.

I changed everything to same as it was previosly, and I am getting the error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError) Get Online Help

Cannot open database "ReportServer$SQLExpress" requested by the login. The login failed. Login failed for user 'NGES\Computer name$'.

Hi,

Maybe you should change the databse connection credential. You can do it on the SSRS Configuration manager on the Database Setup page.

change the credential type from Service Credential to Windows or SQL server credential and type a user name and password with the appropiate permnission in the SSRS Report Server and ReportServerTemp database. that user must be a member of the RSExecRole role in the database.

Another option, to cange the SSRS service credential to a windows account and add the same permission (also if you do it through the SQL Server Config manager, it assigns the appropiate permisson to that user.

regards,

Janos