Jump to content


wefixedit

New Members
  • Posts

    2
  • Joined

  • Last visited

wefixedit's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I faced a similar issue when trying to change the service account used for SQL Service Reporting Services (SSRS). This might help future readers who come across this post: Scenario: In my situation, we were trying to change the service account being used for SSRS. I changed the account used in ConfigMgr and tried changing the account used in Reporting Services Config Manager 2016 (RSCM). The account change in ConfigMgr stuck while the account change in Reporting Services Configuration Manager 2016 didn't and all our ConfigMgr Reports broke. Encryption Keys: Backup the Encryption Keys before doing anything. Then, once you change the account - restore the Encryption Keys you backed up earlier. Because we didn't do this, we had to select the Delete option and assigned the new service account. As a result, we lost all of our custom reports (.RDL files) which could have been backed up easily. Permissions: - Ensure that the Reporting Services service account (sa_sccm_rs) you're referencing is in the Service Account tab of the Reporting Services Configuration Manager. You will get errors if you are trying to assign a service account while running the Reporting Services Config Manager without appropriate SQL permissions. Ask your DBA to help or give yourself SysAdmin permissions in SQL if it's a LAB environment. - Ensure that the account used in ConfigMgr for the Reporting Services Point is using the same account (sa_sccm_rs) you've configured in Reporting Services Configuration Manager. - Ensure that your service account (sa_sccm_rs) has RSExecRole permissions on the ReportServer and ReportServerTempDB databases. What's funny is my issue led me to Garth's post to verify I had setup everything correctly: https://www.enhansoft.com/how-to-install-sql-server-reporting-services-2017/ And to the following link which described exactly what I was doing and where I went wrong: https://www.mssqltips.com/sqlservertip/5787/change-the-sql-server-reporting-services-service-account/
  2. I know this question was answered, but I was looking for the same info and came across your post. Here's another site I found aside from the official Microsoft documentation: https://social.technet.microsoft.com/wiki/contents/articles/11215.system-center-2012-configuration-manager-best-practices.aspx
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.