1. Cannot Use The Special Principal 'sa' Book

The server principal already exists – Msg 15025, Level 16, State 2, Line 1. It’s friday and it’s dark and drizzling outside which usually makes me lazy.,:) But I got this one ticket from one of our customers requesting to create a Login which made me active:D. Well, thought creating a login is just a basic routine security request. Cannot use the special principal 'sa' (Microsoft SQL Server, Error: 15405) After doing some google, I found out the solution which I am sharing so that others can get all the possible solutions from this article. The titled message mean that your sa user is disabled. To enable it, you have to follow below mentioned steps.

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:

Divinity original sin 2 favorite class. Dec 31, 2017 - Divinity: Original Sin 2 General Discussions Topic Details. One we put 88 hours into it and I think it's hands down my favorite COOP game. You could always download mods, they have some pretty fun and nifty classes. I've just started DOS2 and I cannot figure out and pick which class I want. Pretty basic on custom classes, usually sticking to 2/3 per character,. Oct 3, 2017 - Divinity: Original Sin II is a game full of choices: You have to decide where to go, who to talk to, what to say, and whose house to ransack after. Sep 15, 2017 - i would be really interested in some suggestion how to play a melee class with warfare + magic. Does someone has ideas. I tried to find some.

CipherCipher

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.

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_Unbeliever

Cannot Use The Special Principal 'sa' Book

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/

Harsh Baid

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.

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♦

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 ALTER AUTHORIZATION.

Paul White♦Paul White

Not the answer you're looking for? Browse other questions tagged sql-serversql-server-2008-r2 or ask your own question.