<div>
Login to your SQL Server using sa or other sysadmin login and then check whether that login was completely revoked access to all reporting server related databases or not..<br />
Also check whether rsexecrole access was revoked from that user..<br />
And try restarting SSRS once since that user credentials might have been stored in cache...
</div>


Login to your SQL Server using sa or other sysadmin login and then check whether that login was completely revoked access to all reporting server related databases or not..
Also check whether rsexecrole access was revoked from that user..
And try restarting SSRS once since that user credentials might have been stored in cache...

<div>
K - cheked and removed ssrsexecrole access, restarting ssrs service and cleared bowsing cahce - no change, user still acts liek an admin?
</div>


K - cheked and removed ssrsexecrole access, restarting ssrs service and cleared bowsing cahce - no change, user still acts liek an admin?

<div>
<div class="content wysiwyg-content">
Hello - <br />
<br />
I granted a user administrative access to the ssrs web app, and now can't revert back to what it was like before I added him (blank screen).<br />
<br />
I have removed him from all the report folders securities, and removed his ssrs memberships from his user profile on the domain controller.<br />
<br />
However, if I log in as him from his computer, I still have full access as I do with my own administrative account.<br />
<br />
FYI, the other user is my colleague and was testing this out to make sure I understood how to go back and restrict access,<br />
<br />
Thanks 
</div>
</div>


Hello - 

I granted a user administrative access to the ssrs web app, and now can't revert back to what it was like before I added him (blank screen).

I have removed him from all the report folders securities, and removed his ssrs memberships from his user profile on the domain controller.

However, if I log in as him from his computer, I still have full access as I do with my own administrative account.

FYI, the other user is my colleague and was testing this out to make sure I understood how to go back and restrict access,

Thanks 

SSRS Remove A User Account

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.