I set up a user on our staging server for the reporting services to use for its required tasks. Or at least I thought I did. I made a couple of grave errors:
- I did not exempt it from the password policy
- I did not allow it permission to start the Reporting Services service.
Because of 1, when the password expired all reports defaulted back to trying to use my dev Data Source instead of the Data Source I had configured on the server. I updated the password but this seemed to make no difference. (I am assuming that it was the password expiry that triggered this permissions fault, and that it is a permissions fault, the behaviour is that the reports no longer seem able to see shared data sources anyway. I am happy to hear about anything else that may cause this.)
Because of 2 when I tried to restart the service it failed. So to get it running at all I had to change the service account to a built in one. However then it can't access the database, I would rather the Reporting Services Account had permission to start the service, how do I grant it that privilege?