Problem Connecting Report Server to Report Server Database in SSRS

Question

Hi!! I have configured Reporting Services on one Server and have the ReportServerDb & 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.

Any help is highly appreciated.

Thanks in anticipation!!

Cheers!! Vineet

Answer 1

Check to make sure that the domain account you are using has the 'Logon Locally' privelege in your local security policy, most likely on the DB server, but possibly on your report server as well.

Also, try looking at this article. Properly set SPNs are a necessity for SSRS on a server other than the same machine the db is on.