Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot use the special principal "dbo" Expand / Collapse
Author
Message
Posted Thursday, February 3, 2011 4:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 3, 2013 12:12 AM
Points: 48, Visits: 110
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
Post #1058457
Posted Monday, February 7, 2011 2:51 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 16, 2013 6:59 PM
Points: 168, Visits: 350
who's the dbo for the database?

try running sp_changedbowner 'sa' on the db.


-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool :.
Post #1059927
Posted Wednesday, March 27, 2013 7:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 7:23 AM
Points: 1, Visits: 5
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
Post #1435896
Posted Sunday, March 31, 2013 10:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:24 AM
Points: 323, Visits: 532
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.
Post #1437296
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse