Solved

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

Posted on 2013-01-23
3
2,676 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
  • 2
3 Comments
 
LVL 39

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

861 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