SQL Server 2000 – Way to make active orphan users in Database

This is more of a note for my server administrators. Every time they restore databases for past projects they recieve error on unable to connect to login id associated with database. Now when they click on users in database they can see them but cant access them.

The problem is associated with orphan users hence simple problem calls for simple solution

Step 1 : Login using Super Admin into Query Analyzer

Step 2: select database which has been restored

Step 3: Run following command “sp_revokedbaccess ‘username’ ”

Step 4: Run following command “sp_droplogin <username> ”

Boom the user will be deleted and then you can create a new account and link it back to database.

1 Response to “SQL Server 2000 – Way to make active orphan users in Database”


  1. 1 Pawan Kumar February 11, 2008 at 2:09 pm

    Good Post Great Techie.
    Pawan


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Contact Details

E-mail:siddharthpuri@gmail.com Call Me :+91-9910444460
January 2007
M T W T F S S
« Dec   Feb »
1234567
891011121314
15161718192021
22232425262728
293031  

%d bloggers like this: