Ms Sql Server Error 21002
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new mouser threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search digikey | ForumFAQ Register Now and get your question answered! Username: Password: Save Password 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: 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 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 for the user. Edited by - jshurak on 11/15/2006 08:32:24 jshurak Starting Member 44 Posts Posted-11/15/2006: 09:20:28 I just tried the revoke and grant statements with no luck. mcrowley Aged Yak Warrior 771 Posts Posted-11/15/2006: 11:23:
User already exists Discussion in 'General DBA Questions' started by fletcherdunton, Sep 7, 2006. fletcherdunton New Member Here's a basic problem that I should know the answer to, but need help: I cloned a database back from our DEV server to my local server and it had 1 user account called "webuser". That account had execute permissions on about 120 stored proc's. When I try to create this user under my LOCAL Server's SecurityLogin folder, I get the following http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74949 error: "Error 21002: [SQL-DMO] User 'webuser' already exists." So I go to my databaseUser folder and try and delete the account and it tells me "The Selected User Cannot be dropped b/c it owns objects". So I have to right click on it, hit the permissions button and uncheck all 120 exec priv's on the SP's and then delete it.
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for https://www.experts-exchange.com/questions/20299384/Error-21002-SQL-DMO-user-already-exists.html Help Receive Real-Time Help Create a Freelance Project Hire for a http://searchsqlserver.techtarget.com/tutorial/Fast-Guide-Solving-SQL-Server-errors Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error 21002: [SQL-DMO] user already exists Want to Advertise Here? Solved ms sql Error 21002: [SQL-DMO] user already exists Posted on 2002-05-10 MS SQL Server 1 Verified Solution 3 Comments 19,694 Views Last Modified: 2011-08-18 hi all i restored a database called db1 owner of the tables in this database is "owner1" but in my sqlserver "owner1" doesn't exist.=20 so i create a user "owner1" when i ms sql server check the box "db1 can be accessed by owner1", i got this error : = "Error 21002: [SQL-DMO] user owner1 already exists." what can i do? Thanks 0 Question by:denam Facebook Twitter LinkedIn Google LVL 1 Best Solution byMikhail Peterburgskiy I had similar problem when restored db from one server to another. I fixed it using sp_change_users_login From MSDN: sp_change_users_login Changes the relationship between a Microsoft® SQL Server™ Go to Solution 3 Comments LVL 1 Overall: Level 1 MS SQL Server 1 Message Accepted Solution by:Mikhail Peterburgskiy2002-05-11 I had similar problem when restored db from one server to another. I fixed it using sp_change_users_login From MSDN: sp_change_users_login Changes the relationship between a Microsoft® SQL Server™ login and a SQL Server user in the current database. Syntax sp_change_users_login [ @Action = ] 'action' [ , [ @UserNamePattern = ] 'user' ] [ , [ @LoginName = ] 'login' ] You can find documentation in MSDN online http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.a
Performance Tuning SQL Server Administration View All Installation Tools and Utilities Backup and Recovery Availability and Scalability Interoperability Replication Security Stored Procedures T-SQL SQL Server Administration View All Installation Performance Tuning Tools and Utilities Backup and Recovery Availability and Scalability Interoperability Replication Security Stored Procedures T-SQL SQL Server Development View All .Net Development Database Design and Modeling XML SQL Server Management Issues View All Consolidation and Virtualization Career Advice Competitors Compliance Migration and Planning SQL Server Platforms View All SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 BI and Data Warehousing View All Data Visualization Analysis Services Integration Services Reporting Services BI Strategies Data Warehousing Topics Archive View All Please select a category SQL Server Administration SQL Server Development SQL Server Management Issues SQL Server Platforms BI and Data Warehousing Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Fast Guide: Solving SQL Server errors Stumped by a SQL Server error? Troubleshoot the problem right away with this ever-growing list of expert responses and best practices to help you address various error messages. In this Article Share this item with your network: Related Content Problem trying to connect with the sa account – SearchSQLServer Can't log in with 'sa' and 'password' – SearchSQLServer SQL Server connection lost when SA password is changed – SearchSQLServer Sponsored News Hyper-Convergence Delivers Better Mission-Critical Performance –SimpliVity Choosing the Right Hybrid Cloud Solution for Microsoft SQL Server –Rackspace See More Vendor Resources eGuide: Performance tuning SQL Server via queries, indexes and more –Microsoft Database Manageability and Produ