Cannot use the special principal "dbo"

Question

Post reply

Cannot use the special principal "dbo"

smile_netz

Ten Centuries

Points: 1018
More actions
February 3, 2011 at 4:25 pm

#233173

Hi,
In one of our servers, there was a created a login name = <domain>\FarmA
This was assigned as username = 'dbo' to one of the databases (NW2007DB) for SharePoint. This has the db_owner role.
On the database NW2007DB, There was a database role "WSS_Content_Application_Pools" created
When I tried to tick on this database role, it says "Add member failed for role "WSS_Content_Application_Pools"
Additional Information : Cannot use the special principal "dbo"
Please help ...
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Red8Rain Hall of Fame Points: 3312 More actions · Answer 1

who's the dbo for the database?

try running sp_changedbowner 'sa' on the db.

-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.

Mingle Valued Member Points: 73 More actions · Answer 2

I got the same issue. I followed the white paper from Nintex site.http://connect.nintex.com/files/folders/white_papers/entry10989.aspx

But I still have the issue.

_________________
Martin
Email:Martin.Lui@live.com

kevaburg SSCoach Points: 18131 More actions · Answer 3

Red8Rain (2/7/2011)
who's the dbo for the database?
try running sp_changedbowner 'sa' on the db.

I wouldn't recommend the Approach of using 'sa'. Either create an AD user and use that as the owner of the database or create an SQL Server Login. 'sa' should not be used for situations like this.