SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
Difficulty Adding Users to Reporting Services After Upgrade to Version 16.0.1117.32
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 90%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Ricardo Ramos
0
Reputation points
After upgrading our web platform and infrastructure, we are experiencing issues with user access to Reporting Services. Previously, our environment was hosted on Windows Server 2016 with SQL Server 2016 and Reporting Services integrated into a web portal. All users had seamless access to reports.
Recently, we upgraded to:
- Windows Server 2022
- SQL Server Reporting Services Version 16.0.1117.32
Since the upgrade:
- Users can no longer access reports as easily as before.
- We are required to manually add users one by one to grant access.
- The previous configuration allowed bulk or inherited access, which is now missing.
Request: Please advise what configuration settings or permissions might be missing or need to be added in Reporting Services 16.0.1117.32 to restore the previous user access behavior. We aim to replicate the seamless access users had in the older environment.
Additional Notes: The previous servers have been decommissioned, so we cannot retrieve exact version details or configuration files from the old setup.After upgrading our web platform and infrastructure, we are experiencing issues with user access to Reporting Services. Previously, our environment was hosted on Windows Server 2016 with SQL Server 2016 and Reporting Services integrated into a web portal. All users had seamless access to reports.
Recently, we upgraded to:
- Windows Server 2022
- SQL Server Reporting Services Version 16.0.1117.32
Since the upgrade:
- Users can no longer access reports as easily as before.
- We are required to manually add users one by one to grant access.
- The previous configuration allowed bulk or inherited access, which is now missing.
Request: Please advise what configuration settings or permissions might be missing or need to be added in Reporting Services 16.0.1117.32 to restore the previous user access behavior. We aim to replicate the seamless access users had in the older environment.
Additional Notes: The previous servers have been decommissioned, so we cannot retrieve exact version details or configuration files from the old setup.
SQL Server Reporting Services
Sign in to answer