Error 21002 Sql Server
Contents |
360 games PC games Windows sql server error 15025 games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've the server principal already exists restricted the ability to create new threads on these forums. SQL Server Forums exec sp_change_users_login 'report' Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password alter user with login Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) error 21002:[SQL-DMO]User 'xxx' already exists Reply to Topic Printer Friendly Author Topic jshurak Starting Member 44 Posts Posted-11/14/2006: https://support.microsoft.com/en-us/kb/819261 16:53:52 Hello everyone. This is my first post so I hope someone can help me out. After extensively google-ing this error message I have not had any luck resolving this issue. We restored our test server from our production server to test an upgrade. I created a login for a user so they could test, but when I try to give them access http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74949 to specific databases I get this error: error 21002:[SQL-DMO]User 'xxx' already exists. I have run this procedure with no luck:SP_CHANGE_USERS_LOGIN UPDATE_ONE, 'username','login_name'I have also tried this one:sp_change_users_login AUTO_FIX, 'my_user'I've manually dropped and added the user from the system tables but for some reason I can't get past this. I've also checked various links to Microsoft help pages!! AAAGGGHH!! Any help would be greatly appreciated. Thanks ahead of time! Edited by - jshurak on 11/14/2006 16:56:30 khtan In (Som, Ni, Yak) Singapore 17689 Posts Posted-11/14/2006: 17:04:25 tried sp_revokedbaccess & sp_grantdbaccess ?KH mr_mist Grunnio United Kingdom 1870 Posts Posted-11/15/2006: 05:03:09 sp_change_users_login AUTO_FIX, 'my_user'This should work for a sql login assuming that the login name is the same as the user name. Is it a sql login?-------Moo. :) jshurak Starting Member 44 Posts Posted-11/15/2006: 08:28:11 Thanks for the speedy responses. I haven't tried the sp_revokedbaccess & sp_grantdbaccess, I'll give them a try today. It is a SQL login. I have tried the sp_change_users_login AUTO_FIX, but to no avail. I get 'number of orphaned accounts fixed is 0' message.The error occurs when I try to grant specific permissions to databases MSSQL2000 migration database, the same user name when an error http://www.databasesql.info/article/1249326334/ message appears: "Error 21002: [SQL-DMO] User" xxx "already exists" Reason: This is what we usually call "orphaned users", the so-called isolated accounts, is http://www.elitepvpers.com/forum/dekaron-private-server/1187019-error-21002-sql-dmo-user-usernamehere-already-exists.html a database account only the user name and login name, such users in the sysusers system table in the user library, and in sql server the master database in syslogins but there is no corresponding record. Generation of isolated accounts generally two types: 1. Restore the backup database on another machine; Reinstall the system or SQL Server restore only the user library Solution: The solution is to use the sp_change_users_login to repair. sql server error the sp_change_users_login the usage There are three Repair method: Step 1: exec sp_change_users_login 'Report' Orphaned users listed in the current database Step 2: exec sp_change_users_login 'AUTO_FIX', 'username' Can automatically log in to add a user name corresponding to the same name in syslogins Step 3: exec sp_change_users_login 'UPDATE_ONE', 'username', 'login' User Name Mapping for the specified login name. Recommended The Fastpath plugin installation and webchat source development environment installed The DataRelation usage (2), multi-table query Website traffic solution High-performance database "Fourth programming details The Microsoft Data Warehouse Toolkit reading notes (5): Chapter 4 System Installation and physical design Check the database data fields naming norms and legitimacy script Data caching and local storage MSSQL database server can not access Under the SQL Server data batch operation SQL 2005 to modify the primary key of the table © Copyright 2015-2016databasesql.infoContact Best Blogs Blog List Search Blogs elitepvpers > MMORPGs > Dekaron > Dekaron Private Server Error 21002: [SQL/DMO]User 'usernamehere' already exists. You last visited: Today at 20:37 Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Search Blogs Tag Search Advanced Search Go to Page... Please register to post and access all features, it's quick, easy and FREE! Error 21002: [SQL/DMO]User 'usernamehere' already exists. 05/18/2011, 02:11 #1 ryufireblade elite*gold: 0 The Black Market: 0/0/0 Join Date: Apr 2008 Posts: 70 Received Thanks: 3 Error 21002: [SQL/DMO]User 'usernamehere' already exists. Just curious if anyone has gotten this error when you set the database access in sql server 2000, windows xp? Under the sql server login properties, database access, I check the box next to the account database and check the db_owner under the database roles for "account", I hit ok and I get this error, Error 21002: [SQL/DMO]User 'usernamehere' already exists. Any ideas on how to fix this? 05/18/2011, 02:16 #2 =Warmonger= elite*gold: 0 The Black Market: 0/0/0 Join Date: May 2008 Posts: 509 Received Thanks: 1,246 Quote: Originally Posted by ryufireblade Just curious if anyone has gotten this error when you set the database access in sql server 2000, windows xp? Under the sql server login properties, database access, I check the box next to the account database and check the db_owner under the database roles for "account", I hit ok and I get this error, Error 21002: [SQL/DMO]User 'usernamehere' already exists. Any ideas on how to fix this? account database -> users -> delete account Thanks 2 Users 05/18/2011, 02:34 #3 ryufireblade elite*gold: 0 The Black Market: 0/0/0 Join Date: Apr 2008 Posts: 70 Received Thanks: 3 Quote: Originally Posted by Warmonger1337 account database -> users -> delete account That did the trick. I had to do this for the billing, cash, and character databases too. Thanks Warmonger! Solved, can be closed. « Previous Threa