I am trying to set up SQL Server Reporting Services on my server for the first time and am confused about the different between, and recommended settings for, the service account vs. the execution account. Any tips would be greatly appreciated. Thank you.
The service account is used to run the SSRS service under Windows on your server. As with all service accounts you should choose an account that has enough permissions to perform it's job, but not too much (e.g. domain admin!). More details and steps to help deciding the best account to choose can be found [here on MSDN] The execution account is used to allow SSRS to operate under certain circumstances where credentials are not supplied, essentially unattended operations. It is considered best practice to use an account different from any other service account already in use by SSRS. Again avoid wide-ranging permissions but be aware that the account may need access to local and network locations. Configuring the execution account is optional, more details can be found [here on MSDN] :