Error 15405 Cannot Use The Reserved User
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn cannot use special principal sa error 15405 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags error 15405 in sql server Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like
Cannot Use The Special Principal Sa Microsoft Sql Error 15405
you, helping each other. Join them; it only takes a minute: Sign up Cannot use special principal dbo: Error 15405 up vote 25 down vote favorite 2 I am trying to give all the permissions to a user
Cannot Use The Special Principal 'dbo' Sharepoint
in the User Mapping section of a database. But, I am encountering this error: "Cannot use special principal dbo" Server roles of the user: sql-server share|improve this question asked Jan 10 '11 at 6:27 Cipher 2,055164597 1 Not an actual answer to the question posted, but since you're granting db_owner to sarin, why are you even trying to assign any other roles? –Damien_The_Unbeliever Jan 10 '11 at 8:02 This is because I am cannot use the special principal sa user mapping trying to install a CMs on my website and during the installation process, it says, no User or role 'sarin'. See here: i.imgur.com/Intaa.jpg –Cipher Jan 10 '11 at 9:15 1 The user 'sarin' is already db_owner of the database, there's no need to grant any further permissions. If you're still getting this error, then you're not connecting to the database you think you are, but since you've not shown any screenshots of the actual point where you supply server/db/username, or a connection string, it's a little tricky to diagnose further. –Damien_The_Unbeliever Jan 11 '11 at 9:20 add a comment| 3 Answers 3 active oldest votes up vote 32 down vote accepted This is happening because the user 'sarin' is the actual owner of the database "dbemployee" - as such, they can only have db_owner, and cannot be assigned any further database roles. Nor do they need to be. If they're the DB owner, they already have permission to do anything they want to within this database. (To see the owner of the database, open the properties of the database. The Owner is listed on the general tab). To change the owner of the database, you can use sp_changedbowner or ALTER AUTHORIZATION (the latter being apparently the preferred way for future development, but since this kind of thing tends to be a one off...) s
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: 'sa' User Map error SQL Server > SQL Server Security Question 0 Sign in to
Cannot Drop The User 'dbo'.
vote Hello all,I'm having a problem with my sa account, we just migrated cannot alter the user 'dbo' from sql server 2000 to sql server 2005 and 1 of our production applications is failing on the sa login. login failed for user sa I checked the 'User Map' setup to the 'sa' account and the databases that need accessing aren't mapped.When I try to add the map, I get error "Cannot use the special principal http://stackoverflow.com/questions/4644233/cannot-use-special-principal-dbo-error-15405 'sa'. (Microsoft SQL Server, Error: 15405)". I get the same error when trying to remove a user map for sa (there are a couple db's already mapped), and I don't remember how I mapped them in the first place, but it certainly isn't working now!Thanks in advance,102020 Wednesday, September 13, 2006 6:20 PM Reply | Quote Answers 9 Sign in to vote I found the solution!! Quit https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c2dc1237-5a33-48f8-9c11-e2c51424b198/sa-user-map-error?forum=sqlsecurity simple: exec sp_changedbowner 'sa','true'. Thanks anyway Friday, February 16, 2007 7:58 AM Reply | Quote 3 Sign in to vote Hey, I find out how to change it using Management Stadio Express: Right click the database to show properties. then change the owner under files to sa then you can map it under Logins . Thursday, March 15, 2007 8:29 PM Reply | Quote 0 Sign in to vote I have fixed this already, thanks though.The problem was that the db owner was the domain admin and not sa, so I couldn't change the mapping.Thanks,102020 Friday, September 15, 2006 4:10 PM Reply | Quote All replies 0 Sign in to vote What is ther error that you get back and for waht operation do you get it back? Please also check the server error log and copy the relevant errors logged there. ThanksLaurentiu Thursday, September 14, 2006 10:07 PM Reply | Quote Moderator 0 Sign in to vote I have fixed this already, thanks though.The problem was that the db owner was the domain admin and not sa, so I couldn't change the mapping.Thanks,102020 Friday, September 15, 2006 4:10 PM Reply | Quote 0 Sign
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 Error: 15405; Cannot use the reserved user or role name 'dbo' If this is your first visit, be sure to check out the FAQ by clicking http://forums.databasejournal.com/showthread.php?9153-Error-15405-Cannot-use-the-reserved-user-or-role-name-'dbo' 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 http://forums.asp.net/t/902999.aspx?Error+15405+Cannot+use+the+resered+user+or+role+name+sa+HELP+ANY+DBA+s+Out+there of 2 Thread: Error: 15405; Cannot use the reserved user or role name 'dbo' Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-08-2001,10:05 cannot use PM #1 Nana Guest Error: 15405; Cannot use the reserved user or role name 'dbo' Hi all, Problem: When tried to change default permission for 'sa' (just for testing); "Error 15405: Cannot use the reserved user or role name 'dbo'" is displayed. Can anyone suggest to resolve this error? thank you. regards, Nana Reply With Quote 07-10-2001,12:57 AM #2 Kurt Guest Error: 15405; Cannot use the reserved user or role name 'dbo' (reply) You are probably trying to cannot use the drop the dbo role from sa which I don't believe you can do since sa is a kind of 'superuser' and has fixed roles. ------------ Nana at 7/8/01 11:05:52 PM Hi all, Problem: When tried to change default permission for 'sa' (just for testing); "Error 15405: Cannot use the reserved user or role name 'dbo'" is displayed. Can anyone suggest to resolve this error? thank you. regards, Nana Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 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 Programming Database News and Announcements Structured Query Language (SQL) SQL Scripts Database Lounge Feedback Related Sites SQL Course SqlCredit « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off [VIDEO] code is Off HTML code is Off Forum Rules -- New Theme -- Default Mobile Style Contact Us Database Journal Forums Top All times are GMT -5. The time now is 06:54 AM.
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/DataSource Controls - SqlDataSource, ObjectDataSource, etc/Error 15405: Cannot use the resered user or role name 'sa' HELP ANY D... Error 15405: Cannot use the resered user or role name 'sa' HELP ANY DBA's Out there RSS 0 replies Last post Jul 18, 2005 12:58 PM by glabana ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply glabana None 0 Points 128 Posts Error 15405: Cannot use the resered user or role name 'sa' HELP ANY DBA's Out there Jul 18, 2005 12:58 PM|glabana|LINK Hi Here we go another problem I have come across. I',m sure this is a simple for the SQL DBA guru's out there. OS = Win2003 Enterprise Edition SP1 SQL = SQL2k SP4 Problem: I have created another user called "UserOne" and have provided all the database roles and added access to all the DB that I have. Now for security (Maybe I'm wrong here) I want to at least remove all server roles for the user "SA" and remove DB access to all DB's for login "SA". However when doing this task in Enterprise Mgr I get the follwoing error code: Microsoft SQL - DMO (ODBC SQL State: 4200) Error 15405: Cannot use the reserved user or role name 'sa'. I have changed the SQL Registration details so that I connect to SQL Agent via the new Login i.e. (UserOne). Also I have started the SQL Backup agent, however I don't think that this has any effect on the issue (could be wrong) ANY IDEAS STUCK??? Regards Garry ‹ Previous Thread|Next Thread › This site is managed for Microsoft by Neudesic, LLC. | © 2016 Microsoft. All rights reserved. Privacy Statement| Terms of Use| Contact Us| Advertise With Us| CMS by Umbraco| Hosted on Microsoft Azure Feedback on ASP.NET| File Bugs| Support Lifecycle