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

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
LVL 4
Kennyboy5IT Support AnalystAsked:
Who is Participating?
 
Kennyboy5Connect With a Mentor IT Support AnalystAuthor Commented:
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
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
Kennyboy5IT Support AnalystAuthor Commented:
My query was the fix to the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.