Error 21770
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 threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums Old Forums CLOSED - General SQL Server error 21770: [SQL-DMO] Forum Locked Printer Friendly Author Topic awojtowicz Starting Member USA 3 Posts Posted-05/24/2006: 11:44:40 I'm running SQL 2000 with latest SP. if i go and right click a database and click on properties i get this error message. "error 21770 :[SQL-DMO]The name '(null)' was not found in the specified collection."i hit okay and then it opens. any idea why? this just started. everything seems fine. i don't have any reports of problems. Topic Forum Locked Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and Replication (2000) Transact-SQL (2000) Analysis Services (2000) MSDE (2000) Development Tools ASP.NET Reporting Services Development Other Development Tools Site Related Forums Site Related Discussions Article Discussion Poll Discussion The Yak Corral Other Forums SQL Server 6.5 \ SQL Server 7.0 Other Topics MS Access ClearTrace Support Forum Old Forums CLOSED - Gener
New? Advanced Search Forum Miscellaneous General Database Discussions ERROR 21770 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: ERROR 21770 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-07-1999,10:11 AM #1 Phil Durham Guest http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66657 ERROR 21770 I am receiving the following error when adding an alias to DBO using manage users in Enterprise Manager. Error 21770 The Name '' was not found in the logins collection The alias does take but I am not sure why the message appears. This is happening only in one database on the server. I am running Version 6.5 SP5a I get no message when running sp_addalias it http://forums.databasejournal.com/showthread.php?7573-ERROR-21770 works fine. Thanks, Phil Reply With Quote 06-07-1999,12:24 PM #2 Cindy Gross Guest ERROR 21770 (reply) TechNet or support.microsoft.com: BUG: Error 21770 Adding Login in SEM and User with SP_ADDUSER PSS ID Number: Q223999 Article last modified on 04-14-1999 Basically, when you have to "refresh" the logins so that the GUI tool re-reads the database to see the logon you just added. ------------ Phil Durham at 6/7/99 11:11:43 AM I am receiving the following error when adding an alias to DBO using manage users in Enterprise Manager. Error 21770 The Name '' was not found in the logins collection The alias does take but I am not sure why the message appears. This is happening only in one database on the server. I am running Version 6.5 SP5a I get no message when running sp_addalias it works fine. Thanks, Phil Reply With Quote Quick Navigation General Database Discussions Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM DB2 Informix Microsoft Access Microsoft SQL Server 2008 Microsoft SQL Server 2005 MDX and Analysis Services Reporting Services MS SQL Server 7/MS SQL Server 2000 MySQL Oracle PostgreSQL Sybase Miscellaneous General Database Discussions Ask an Expert Database Design Database Progr
on Twitter Share on Google+ Share on Pinterest Share by Email × Question about Canon CanoScan Scanners Open Question Canoscan 3200 error code 21770, can not scan - CanoScan Canon Scanners Posted by Anonymous on Mar 17, 2013 Want Answer 0 Clicking this http://www.fixya.com/support/t17181220-canoscan_3200_error_code_21770_not_scan will make more experts see the question and we will remind you when it gets http://www.bigresource.com/MS_SQL-sp_addlogin-sp_adduser-Error-21770-l0DQKv2f.html answered. Comment Flag More Print this page Share this page × Moderate Help this question get an answer Is this question mis-categorized or about a different product? Help this question get an answer by entering the correct category or product below. Did you mean? Yes No Cancel Update (+2 points) You can't post conmments that contain an email address. error 21770 × Comment Anonymously Video Images Add Your Answer Tips for a great answer: - Answer the question. - If you need clarification, ask it in the comment box above. - Better answers use proper spelling and grammar. - Provide details, support with references or personal experience. Tell us some more! Your answer needs to include more details to help people. You can't post answers that contain an email address. Please enter a valid email error 21770 address. The email address entered is already associated to an account.Login to post Please use English characters only. Tip: The max point reward for answering a question is 15. 0 characters Video Photos Link Replacement Parts Add Upload Upload × × Draw a box over the problem!! Edit Close Save changes Attachments: Added items Uploading: 0% my-video-file.mp4 Complete. Click "Add" to insert your video. Add × Loading... Include an image. It's worth a thousand words. prev next 1 Points Related Questions: 1 Answer Canon scanner error code:5,156,69 Google it May 30, 2015 | Canon LiDE 120 CanoScan 1 Answer Canoscan 3200 code : 2,177,0 twain data transfer error scangear cs error in scanner Please test it by disconnecting and reconnecting the scanner. Mar 03, 2014 | Canon CanoScan 3200F Flatbed Scanner 2 Answers Internal error occured code: 5,202,52 after installing Canon CanoScan Lide 210 Perhaps you have forgotten to unplug the scanner before scanning? That's what happened to me. I kept getting different error codes, 5,202,63 or 5,202,52 or 5,202,54 and also a message that the driver was not in the TWAIN folder. According to the help file the problem might have been due to my nfts file system. I also tried downloading various new drivers. Nothing helped until I noticed that I had not unplugged the scanner! Apr 11, 20
that basically acts a a wrapper around the SQL Server stored procedures. It partially works - here is my procedure: create procedure AddUserToSQLServer(@loginame varchar(30), @Password varchar(30) ) as begin -- Add User to SQL Server Database exec mydb.dbo.sp_addlogin @loginame,@Password,'mydb' exec mydb.dbo.sp_adduser @loginame end The sp_addlogin adds the login and sets the default database as mydb. This is OK, except the user still can not login to the application. So I added the sp_adduser. This gives the user access to the application, but I still have a problem. When I go into Executive Manager, and go to the Manage Logins screen by double-clicking on the newly added user, I get the message "Error 21770: The name 'loginame' was not found in the users collection" where loginame is the users login. I click OK to this message, and the user is displayed on the manage logins screen. Their default database is mydb, a check is in the Permit box and their username is in the User column. Alias and Group are blank. When I try to drop the user, I get the same error again (2 times), then error "Error 15175: [SQL Server] login 'loginame' is aliased or mapped to a user in one or more database(s), drop user or alias before dropping login". The only thing I found that works is to go to SQL and issue sp_dropuser loginame, then I can drop the user. Anybody see what's wrong? Or know of a FAQ that addresses this situation? Thanks Wayne View 1 Replies Similar Messages: ERROR 21770 Error 21770 Adding New User Sp_adduser Sp_adduser And The Old Question Of Why?? Who Can Execute Sp_adduser ? Using Custom Sp_adduser Sp_adduser To Database? Sp_addlogin Sp_addlogin How To Use Sp_addlogin Sp_addlogin (SQL2K) Need Sp_addlogin With CHECK_POLICY = OFF Sp_addlogin With @encryptopt = 'skip_encryption' SQL Server 2005 SP_ADDLOGIN Forcing Password Policy By Modifying Sp_addlogin Does Security Admin Have Access To Create Logins Using Sp_addlogin SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. ) [File System Task] Error: An Error Occurred With The Following Error Message: Access To The Path Is Denied Exec Pkg Task: Error 0xC0202009 While Preparing To Load The Package. An OLE DB Error Has O