Cannot use the special principal "dbo"

  • 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

  • who's the dbo for the database?

    try running sp_changedbowner 'sa' on the db.

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

  • 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

  • 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.

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

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