Error 15023: User already exists in current database

Dear Group,
Can someone please help me with this problem.
I'm trying to add a new User to a particular database but
keep getting the above error, telling me that the user
already exists in the current database. When I look in
the Permissions in the database Properties, the only
user/role is public.
What can I do?
Maree.You have orphaned users to the syslogins table in the master database (EM doesn't show such). I
assume you did an attach or restore of the database...
Read about sp_change_users_login and/or use a GUI on top of the proc available at www.dbmaint.com,
free utilities.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Maree" <eeramstu@.yahoo.com.au> wrote in message news:0f8001c387b9$7d459ec0$a101280a@.phx.gbl...
> Dear Group,
> Can someone please help me with this problem.
> I'm trying to add a new User to a particular database but
> keep getting the above error, telling me that the user
> already exists in the current database. When I look in
> the Permissions in the database Properties, the only
> user/role is public.
> What can I do?
> Maree.|||Thank you so much Tibor!!
>--Original Message--
>You have orphaned users to the syslogins table in the
master database (EM doesn't show such). I
>assume you did an attach or restore of the database...
>Read about sp_change_users_login and/or use a GUI on top
of the proc available at www.dbmaint.com,
>free utilities.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>"Maree" <eeramstu@.yahoo.com.au> wrote in message
news:0f8001c387b9$7d459ec0$a101280a@.phx.gbl...
>> Dear Group,
>> Can someone please help me with this problem.
>> I'm trying to add a new User to a particular database
but
>> keep getting the above error, telling me that the user
>> already exists in the current database. When I look in
>> the Permissions in the database Properties, the only
>> user/role is public.
>> What can I do?
>> Maree.
>
>.
>sql