Solved

Trying to set user mapping of the 'sa' account to a database but it errors out

Posted on 2013-01-23
3
2,731 Views
Last Modified: 2013-01-28
Hello,
 We've been moving a couple of databases from an old 2000 server to a new VM with SQL Server 2008 Standard. In 2008 if I right click on the 'sa' user and go to properties and then on the left go to User Mapping, I can't put a check mark beside my database that I've restored and set it to db_owner. I get the error:
Cannot use the special principal 'sa' (Microsoft SQL Server, Error: 15405)
But yet in the old 2000 server you could set the database role of db_owner to our databases.
Is this not possible in 2008 standard or is it just 'understood' that the db_owner is 'sa'?
What we need is to be able to see that 'sa' is in the db_owner role with our database.

Thank you,
KB5
0
Comment
Question by:Kennyboy5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 200 total points
ID: 38810863
The error above is clear because SA sql account IS "dbo" and please try change that under "User" and also under "Schema" when making the change.
"Cannot use the special principal 'sa' (Microsoft SQL Server, Error: 15405)"
0
 
LVL 4

Accepted Solution

by:
Kennyboy5 earned 0 total points
ID: 38810948
It is the owner but it just wasn't showing it. I had to run a query on the database to fix it.
use TheNameOfYourDatabase
exec sp_changedbowner 'sa', 'true' 

Open in new window


Now shows sa as the dbo.
0
 
LVL 4

Author Closing Comment

by:Kennyboy5
ID: 38826168
My query was the fix to the problem.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
This query failed in sql 2014 5 39
Help Required 3 118
Separate 2 comma delimited columns into separate rows 2 46
Split string into 3 separate fields 5 22
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question