?
Solved

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

Posted on 2013-01-23
3
Medium Priority
?
2,912 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 800 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

762 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