Jon hit the point -- it's an easy fix once we located the problem.

Thanks Jon and everybody trying to help!

-----Original Message-----
From: Helsel, Jon A. [mailto:Helsel.[Email Address Removed] Thursday, July 11, 2002 10:33 AM
To: Fang, Elaine
Subject: RE: URGENT -- why can't I see the user in this db?


Articles exist on Orphaned Logins when moving DB between servers. BOL has some good literature "Troubleshooting Orphaned Users".......jh


> -----Original Message-----
> From: Fang, Elaine [SMTP:Elaine.[Email Address Removed] Sent: Thursday, July 11, 2002 10:28 AM
> To: [Email Address Removed] Subject: URGENT -- why can't I see the user in this db?
>
> Hi gurus,
>
> I have a customer did a DB restore from previous complete backup this morning since they has a server crash (sounds like they lost a hard drive). The DB restored OK but they are experiencing problems to login w/ the user that exist in the DB before. The User we had trouble now called eic_user, it should be located in eic db, and associated with login eic_user.
> After looked at their db, I found:
>
> 1. The user name (eic_user) was not listed as an user under target db (eic).
> 2. If I do select name from sysuser, eic_user does come back.
> (but I don't kown which db it belongs to, how can I check that?)
> 3. The login (eic_user) was there on the server but it was not given permit to eic db.
> And if I tried to give permit for that login to eic database, I got error
> 15032: User or role with that name already exist in that db.
>
> Can you help me on what happened here? Shall I drop both the login and user and get them recreated?
>
> Thanks!
>
> Elaine
>
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page