Situatie
Solutie
SSRS has its own security model that is separate from SQL Server’s database-level permissions.
Steps:
1. Open the SSRS Web Portal
Go to: http://<ServerName>/Reports (or the URL configured for your SSRS instance).
2. Go to Site Settings (for site-wide permissions) or open the specific folder/report you want to secure.
3. Assign Roles:
Click Manage → Security.
Click Add group or user.
Enter the user’s Windows account in the format: DOMAIN\username
Assign an SSRS role:
i.Browser → View reports
ii.Publisher → Publish reports
iii.Content Manager → Full control
Leave A Comment?