I can't Remove user that is no longer in Active Directory.

Question

I can't Remove user that is no longer in Active Directory.

grwoods

SSC Enthusiast

Points: 166
More actions
January 25, 2010 at 1:22 pm

#229379

So I'm trying to add someone as an admin in the Sitewide settings. And I keep getting: The user or group name 'Domain\User' is not recognized. (rsUnknownUserName)
It references the previous admins account which I know is no longer in Active Directory. This is SSRS 2005 SP2 runninng on Server 2003 SP2.
How can I get around this? I'm an admin on the machine as well as on the SQL side. This is really strange.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110651 More actions · Answer 1

If I take your title together with the rest of the post, I might come to the conclusion that somehow, you're presenting the old SID due to some kind of saved login scenario. If that's the case, then fixing is a matter of finding out how/where that login save is stored and finding out how to remove it so you can supply a fresh set of credentials. Is that a possibility?

Steve

(aka sgmunson)

:-):-):-)

grwoods (1/25/2010)
So I'm trying to add someone as an admin in the Sitewide settings. And I keep getting: The user or group name 'Domain\User' is not recognized. (rsUnknownUserName)
It references the previous admins account which I know is no longer in Active Directory. This is SSRS 2005 SP2 runninng on Server 2003 SP2.
How can I get around this? I'm an admin on the machine as well as on the SQL side. This is really strange.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

grwoods SSC Enthusiast Points: 166 More actions · Answer 2

The problem is that the only users listed with the sys admin role are no longer in Active directory. I have looked around in the report server database tables and can see them listed in the Policy tables and such. I just don't think it will do any good to try and remove them there. It seems to check AD for those users and choke no matter what action I take. I'm at a total loss on this one.

sgmunson SSC Guru Points: 110651 More actions · Answer 3

Have you tried using the SA account ?

Steve

(aka sgmunson)

:-):-):-)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

grwoods SSC Enthusiast Points: 166 More actions · Answer 4

sgmunson (1/28/2010)

Have you tried using the SA account ?

You can't log into reporting services as sa.

I logged into RS using SSMS and tried to add myself as admin and got.

The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

So basically I can't remove the old guys accounts. And I can't add myself. So effectively there is no sitewide admin for Reporting services.

grwoods SSC Enthusiast Points: 166 More actions · Answer 5

So the only way out of this dilema is to detach the report server database and create a new one.

The down side is you have to redo all of the security settings for your reports after you deploy them.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 6

Before you detatch the database and such I'd sugggest you try one other thing first.

Add yourself to the local machine Adminsitrators Group. By default this group should have admin rights on the SSRS instance unless this has been turned off somewhere along the lines...

To help us help you read this[/url]For better help with performance problems please read this[/url]

grwoods SSC Enthusiast Points: 166 More actions · Answer 7

I was already in that group. That's what is so insidious about this bug.

By the way RsScripter helps make the replacement process much less painful. You can just dowload and script everything.

Then run the script to redeploy. 🙂