I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.
When I try to run the SP (on server X), I get the following message:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITY\NETWORK SERVICE'.
Hi,
Try to change the SSRS service account to a domain account, and add this account to your SSRS database server and map to your SSRS database. Also, you should add this account to the RsExecRole role.
I hope it helps.
Regards,
Janos
No comments:
Post a Comment