July 29, 2015 at 5:54 am
Hi Team
I am configuring a report server 2008 r2 , I choose the existing reportserver DB. But i am getting SQL permission error.
I have read, write, execute permissions on the reportserver DB. Can you please let me know what SQL roles are required on the service account on the ReportServer db's ?
July 31, 2015 at 3:17 am
Hi,
Based on ( https://msdn.microsoft.com/en-us/library/ms160340.aspx ), when use RSCM to change service account, it will automatically updates the login permissions on the SQL Server Database Engine instance used to host the report server database. The new account will be added to the RSExecRole. So please change service account to a available one in RSCM.
Since you mention you get the error message, please check the SSRS log files(C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles) to find detail error information.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply