Error 15405 Cannot Use The Reserved User Or Role Name
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
Cannot Use The Special Principal Sa Microsoft Sql Error 15405
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions cannot use the special principal 'dbo' sharepoint Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million cannot use the special principal sa user mapping programmers, just like 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
Cannot Drop The User 'dbo'.
permissions to a user 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
Cannot Alter The User 'dbo'
This is because I am 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,
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 vote Hello all,I'm login failed for user sa having a problem with my sa account, we just migrated from sql server 2000
Sp_changedbowner
to sql server 2005 and 1 of our production applications is failing on the sa login. I checked the 'User Map' alter authorization on database 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 'sa'. (Microsoft SQL Server, Error: 15405)". I http://stackoverflow.com/questions/4644233/cannot-use-special-principal-dbo-error-15405 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 simple: exec sp_changedbowner 'sa','true'. Thanks anyway Friday, February 16, 2007 7:58 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c2dc1237-5a33-48f8-9c11-e2c51424b198/sa-user-map-error?forum=sqlsecurity 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 in to vote Hi, I have the same problem. I am trying to add sa to several databases created by other users than sa. We are getting error 1
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » http://www.sqlservercentral.com/Forums/Topic581674-119-1.aspx Testing Center » SQL Server Security Skills » Error 15405: Cannot use the reserved user or... Error 15405: Cannot use the reserved user or role name 'sa' Rate Topic Display Mode Topic Options Author Message priyadevspriyadevs Posted Tuesday, October 7, 2008 5:08 AM Forum Newbie Group: General Forum Members Last Login: Tuesday, April 7, 2009 6:04 AM Points: 1, Visits: cannot use 2 Error 15405: Cannot use the reserved user or role name 'sa' Post #581674 allimutallimut Posted Sunday, January 4, 2009 2:09 PM Forum Newbie Group: General Forum Members Last Login: Sunday, January 4, 2009 2:08 PM Points: 1, Visits: 0 priyadevs (10/7/2008)Error 15405: Cannot use the reserved user or role name 'sa'Error 15405: Cannot use the reserved user or role name cannot use the 'sa' Post #629510 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You cannot send private messages. You cannot send emails. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot post or upload images. Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.