20 Comments
Few days ago, I have wrote about SQL SERVER – DISABLE and ENABLE user SA I received following email from one of the user who received following error.
Msg 15151, Level 16, State 1, Line 2
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.
Fix/Workaround/Solution:
This error had occurred because of insufficient rights. Please read my previous post here before reading further article.
This error had occurred because of insufficient rights. Please read my previous post here before reading further article.
SA is system admin user and it is the highest level of user in system. If any user have to modify the permissions of SA that user needs to have higher or equivalent rights as SA user. Users member of systemadmin group are can only change the rights of SA user.
First adding any user to systemadmin role and then using the same user to modify system admin’s tool will fix the issue.
Saran drama yang bagus untuk anak kuliahan mp3. Reference : Pinal Dave (https://blog.sqlauthority.com)
Instant Learning | SQL Server Performance Tuning Practical Workshop for EVERYONE
Sep 20 | Prague | Pre-Con: 21 Essential Scripts: Performance Tuning (Details – Register)
Sep 30 | Netherlands | Pre-Con: 0 (Zero) to Hero: 21 Essential Performance Scripts (Details – Register)
Sep 30 | Netherlands | Pre-Con: 0 (Zero) to Hero: 21 Essential Performance Scripts (Details – Register)
SQL Error Messages, SQL Scripts, SQL Server Security
I am trying to give all the 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:
CipherCipher2,5141717 gold badges6666 silver badges106106 bronze badges
3 Answers
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.
In, the player will generally rely upon their war party to carry fights that they and their alone would not be capable of handling. Mount and blade troop tree. Contents Melee InfantryEvery faction but the Khergit Khanate have a specialized melee infantry unit.
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..)
Damien_The_UnbelieverDamien_The_Unbeliever201k1717 gold badges262262 silver badges354354 bronze badges
Fix: Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405
When importing a database in your SQL instance you would find yourself with Cannot use the special principal 'sa'. Microsoft SQL Server, Error: 15405 popping out when setting the sa user as the DBO of the database. To fix this,Open SQL Management Studio and Click New Query. Type:
Close the new query and after viewing the security of the sa, you will find that that sa is the DBO of the database. (14444)
Source:http://www.noelpulis.com/fix-cannot-use-the-special-principal-sa-microsoft-sql-server-error-15405/
Cannot Use The Special Principal 'sa' Test
Harsh Baid6,14055 gold badges3939 silver badges8383 bronze badges
ChiakoChiako
This answer doesn't help for SQL databases where SharePoint is connected. db_securityadmin is required for the configuration databases. In order to add db_securityadmin, you will need to change the owner of the database to an administrative account. You can use that account just for dbo roles.
user2120935user2120935
Not the answer you're looking for? Browse other questions tagged sql-server or ask your own question.
This question already has an answer here:
- Why is CDC capture failing due to a missing dbo principal 2 answers
I restored a backup of a database from SQL Server 2008 R2 to SQL Server 2012.
When I try to access a particular page of my application, I get this error:
Cannot execute as the database principal because the principal 'dbo' does not exist
It works with my 2008 R2 project perfectly. How can I resolve this issue?
Paul White♦57.1k1515 gold badges301301 silver badges474474 bronze badges
Cannot Use The Special Principal 'sa' Teacher
LiquidLiquid
marked as duplicate by Paul White♦Aug 19 '15 at 23:32
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
migrated from stackoverflow.comAug 19 '15 at 10:34
This question came from our site for professional and enthusiast programmers.
1 Answer
You need to give the database a valid owner. Use the
ALTER AUTHORIZATION
command to do this:Note the sp_changedbowner system stored procedure has been deprecated in favour of
Paul White♦Paul WhiteALTER AUTHORIZATION
.57.1k1515 gold badges301301 silver badges474474 bronze badges
Not the answer you're looking for? Browse other questions tagged sql-serversql-server-2008-r2 or ask your own question.
20 Comments
Few days ago, I have wrote about SQL SERVER – DISABLE and ENABLE user SA I received following email from one of the user who received following error.
Msg 15151, Level 16, State 1, Line 2
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.
Cannot alter the login ‘sa’, because it does not exist or you do not have permission.
Fix/Workaround/Solution:
This error had occurred because of insufficient rights. Please read my previous post here before reading further article.
This error had occurred because of insufficient rights. Please read my previous post here before reading further article.
SA is system admin user and it is the highest level of user in system. If any user have to modify the permissions of SA that user needs to have higher or equivalent rights as SA user. Users member of systemadmin group are can only change the rights of SA user.
First adding any user to systemadmin role and then using the same user to modify system admin’s tool will fix the issue.
Reference : Pinal Dave (https://blog.sqlauthority.com)
Instant Learning | SQL Server Performance Tuning Practical Workshop for EVERYONE
Sep 20 | Prague | Pre-Con: 21 Essential Scripts: Performance Tuning (Details – Register)
Sep 30 | Netherlands | Pre-Con: 0 (Zero) to Hero: 21 Essential Performance Scripts (Details – Register)
Sep 30 | Netherlands | Pre-Con: 0 (Zero) to Hero: 21 Essential Performance Scripts (Details – Register)
SQL Error Messages, SQL Scripts, SQL Server Security
Using sql Server 2005
Everything was working fine, then I got up one morning and everything was haywire.I am working on a web site and when I try to login in I get the error message
Login failed for user 'SA' because the account is currently locked out.
I went to my SQL Server and was able to log in using my windows authentication.
1.My Server is set up for Sql Server and Windows Authentication mode
2.Most of the database permissions for sa were gone.When I tried to adder use SA to any database role I got the error message Cannot use the special Principal SA (Sql Server Error message 15405)
3.I logged on to the server as SA and got the same results listed above.
4.I don’t have a problem any other Sql Server logins permissions in my database – it only seems to be a problem with SA.
5.I have tried shutting down the server (Sql Server) and restarting it, but that didn’t fix the problem.
As I said before, this all seemed to have happened overnight.I am the only one using this server right now so I can’t figure out how these changes happened.
I am using the evaluation copy of Windows Server for Small business Server, Build 3790 with SP1.I have only been using it for 3 weeks so I am a long way from the end of the evaluation period, so I don’t think that is the problem.
Do you have an explanation or solution for this problem?Any feedback would be appreciated.