Fix Users cannot self-subscribe to SSRS reports

I locked down some permissions on our SCCM server today and afterward found that my non-admin account could no longer self-subscribe to reports.  Here's how to correct that should you find yourself in a similar situation:

Open SQL Server Management Studio

• In the "Connect to Server" window, Server Type = Reporting Services, Server Name = YourSQLServerReportingServer
• Expand Security > Roles > Right click, properties on ConfigMgr Reports Users
• Check and enable Manage individual subscriptions and click OK

That change will be immediate and will allow self-subscription but only to the user's AD alias.  In my case (and I'm sure many others) the alias that it wants to use is not a full email address so you will have to continue with this next step.  As I said, that change is immediate so just go and see if things work the way you want them.  If you have the problem that I do, the email address is no good, then continue with this next part.


On the SSRS server locate the file "RSReportServer.config".  Double-check its location to be sure it is actually the one that SSRS is using and not just some random copy.  In that file:

• In RSReportServer.config, locate the item "<SendEmailToUserAlias>"
• Change the value of <SendEmailToUserAlias> from true to false
• Stop the SSRS service
• Stop the Worldwide Web Publishing service
• Start the Worldwide Web Publishing service
• Start the SSRS service

When you re-connect to the SSRS server in your browser at this point it will take a long time to open the page as it will re-initialize the site.  Will only be slow the first time, but just wanted to warn you it will take a couple minutes on first connect.


That should do it, your users should now be able to self-subscribe.


If you find this useful please give a +1, leave a comment, or link back to this blog post.
Thanks and enjoy!