Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists.

From: Mukul Agochiya (magochiya@yahoo.com)
Date: 03/12/03 

From: "Mukul Agochiya" <magochiya@yahoo.com>
Date: Wed, 12 Mar 2003 08:54:45 -0800

1. No restoration of database was performed.
2. I do not see that user account as orphaned.

But real issue is that this new user account is not being
saved with necessary permissions for the selected database.

Mukul

>-----Original Message-----
>Was the user database restored or attached? In this
case, you may have
>orphaned users. You can remedy this with
sp_change_users_login.
>Alternatively, you can drop the user from the database
using
>sp_revokedbaccess from Query Analyzer.
>See the Books Online for details.
>
>--
>Hope this helps.
>
>Dan Guzman
>SQL Server MVP
>
>-----------------------
>SQL FAQ links (courtesy Neil Pike):
>
>http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>http://www.sqlserverfaq.com
>http://www.mssqlserver.com/faq
>-----------------------
>
>"Mukul Agochiya" <magochiya@yahoo.com> wrote in message
>news:085901c2e8b3$50bba520$a501280a@phx.gbl...
>> I created a new user where we logged as 'SA'. I assigned
>> permissions to certain databases. While saving it, I got
>> this error message:
>>
>> Error: 21002: [ SQL-DMO] User "xxxxx" already exists.
>>
>> Can you please let me know how to resolve this. I know
>> that we can grant permissions using T-SQL.
>>
>> Secondly, if we delete this newly created user account,
>> then it is still visible under different user roles
>> defined earlier. It does not delete the user account
from
>> the roles completely.
>>
>> I will appreciate if somebody can give hint how to
resolve
>> these issues.
>>
>> Mukul
>
>
>.
>

Relevant Pages

  • Re: Log In
    ... knowledge about security for database. ... I want to set user account and ... accomplishing it? ... I have my database i want to share to some of my colleagues for updating. ...
    (microsoft.public.access.security)
  • RE: No search results from non-portal content
    ... Central Administration and under Server Configuration, ... Have the customer add a user account with Local Administrator ... Roles Tab check off Systems Administrator, Security Administrator, Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Whitepaper on win2003 DNS performance ?
    ... That sounds more of an NT4 ... I recommend anyone to use this tool who needs to estimate database size, ... (because of less attributes per user account and mail-enabled group ... So Herb, please check YOUR math. ...
    (microsoft.public.win2000.dns)
  • Re: Entourage 2008 Crashing on Preferences
    ... up my exchange webmail account in the new user account - perhaps I should try ... How to rebuild: ... if your database is very large, be sure to check how much free space ... Place the script in the Script Menu Items folder in the Microsoft User Data ...
    (microsoft.public.mac.office.entourage)
  • Only one user can log in at a time problem.
    ... I have an Access database splitted into FE & BE. ... workgroup are placed in the same folder in a network drive. ... I created an user account called "mfg" ...
    (microsoft.public.access.security)