[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SSRS Remove A User Account

Posted on 2009-12-17
Medium Priority
Last Modified: 2012-08-14
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,

Question by:nosehead2000
  • 3
  • 2
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26077569
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...

Author Comment

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

Accepted Solution

Raja Jegan R earned 2000 total points
ID: 26077632
Kindly confirm whether that user is part of Builtin\Administrator role on that server..
If so kindly revoke and test..

Author Comment

ID: 26077874
Nailed it, thanks!
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26077949

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question