February 4, 2009 at 8:40 am
Hi all -
I'm having a problem dropping an orphaned user and wondered if any of you could help. This is my first time posting. Please forgive my lack of experience.
Here's my problem: On a SQL Server 2000 instance, I have a user that comes up in my sysusers table that doesn't have an associated login - orphaned user. I can't find the user when navigating to the Database >> Security >> Users area in SSMS. Weird. I also don't see the user being associated with any roles either. I tried googling to see if there was another way to drop the user and I found the exec sp_dropuser, exec sp_droplogin, and exec sp_revokelogin stored procedures. I can revoke the login just fine, but when I try to drop the login or user, I get a login or user doesn't exist error message.
Any ideas what could be going on? I've had no problems deleting other orphaned users thus far.
Thanks for your help in advance!
February 4, 2009 at 8:46 am
Then try creating a new login with same name as this user and associate that login with this user. Once it comes up under security-->users GUI then drop the user first followed by login..
HTH!
MJ
February 4, 2009 at 8:59 am
That worked like a charm. Thanks for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply