Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists.
From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 03/12/03
- Next message: Terry Heckrote: "Accessing Windows group members"
- Previous message: Mukul Agochiya: "Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- In reply to: Mukul Agochiya: "Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- Next in thread: Mukul Agochiya: "Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- Reply: Mukul Agochiya: "Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dan Guzman" <danguzman@nospam-earthlink.net> Date: Wed, 12 Mar 2003 10:32:38 -0600
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
- Next message: Terry Heckrote: "Accessing Windows group members"
- Previous message: Mukul Agochiya: "Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- In reply to: Mukul Agochiya: "Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- Next in thread: Mukul Agochiya: "Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- Reply: Mukul Agochiya: "Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
