locked
SQL Server Permission Issue? RRS feed

  • Question

  • Can anyone provide additional help with the below error?  Under user mapping a set back the Master DB and TRAINBASE DB to the same owner, and still ge the error.  Any Ideas?

    Msg 33009, Level 16, State 2, Line 3

    The database owner SID recorded in the master database differs from the database owner SID recorded in database 'TRAINBASE'. You should correct this situation by resetting the owner of database 'TRAINBASE' using the ALTER AUTHORIZATION statement
    Jack Galante Sr Systems Engineer
    Tuesday, November 29, 2011 9:37 PM

Answers

  • Have you reset the owner of the Database by using ALTER AUTHORIZATION as avised in the error message?
    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    • Marked as answer by Maggie Luo Tuesday, December 6, 2011 1:28 AM
    Wednesday, November 30, 2011 2:40 AM
  • In addition to Jeff's reply http://msdn.microsoft.com/en-us/library/ms187359.aspx
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Maggie Luo Tuesday, December 6, 2011 1:28 AM
    Wednesday, November 30, 2011 4:27 AM

All replies

  • Have you reset the owner of the Database by using ALTER AUTHORIZATION as avised in the error message?
    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    • Marked as answer by Maggie Luo Tuesday, December 6, 2011 1:28 AM
    Wednesday, November 30, 2011 2:40 AM
  • In addition to Jeff's reply http://msdn.microsoft.com/en-us/library/ms187359.aspx
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Maggie Luo Tuesday, December 6, 2011 1:28 AM
    Wednesday, November 30, 2011 4:27 AM
  • Thanks that worked !
    Jack Galante Sr Systems Engineer
    Monday, December 5, 2011 4:28 PM