Problem Connecting Report Server to Report Server Database in SSRS I have configured Reporting Services on one Server and have the ReportServerDb and ReportServerTempDb on other server (Future requirement of scale out deployment).

I am connecting to these servers using a domain account. I have configured Reporting Services using ReportingServiceConfiguration Wizard and it seems to have worked fine except that the Initialization tab does not have the green tick in front (not initialized). 

The error I get is:


  The report server cannot open a connection to the report server
  database. The logon failed. (rsReportServerDatabaseLogonFailed) Get
  Online Help Logon failure: the user has not been granted the requested
  logon type at this computer. (Exception from HRESULT: 0x80070569)


The domain account I have used is perfectly fine and I am able to connect using SSMS (No Password errors). I have searched through many a blogs, forums etc, but have not been able to find a solution.
Re-run through the database configuration part to select the same database and it will re-issue the grants to make sure the permissions are in place, but make sure the account you run the wizard with has sysadmin access to the instance.  If it's 2005 you can generate the grant script but it's kind of buggy.