Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: Error while creating assembly

    I am trying to create an assembly on a sql server 2005 machine but it gives me following error:


    Msg 33009, Level 16, State 2, Line 2
    The database owner SID recorded in the master database differs from the database owner SID recorded in database 'XYZ'. You should correct this situation by resetting the owner of database 'XYZ' using the ALTER AUTHORIZATION statement.



    I tried using the alter authorization statement to change the owner.
    It did not work.

    I am able to create same assembly on another test database but can not create it on this database.

    Is this because of orphan logins?

    Thanks for the help.

    Harshal.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Was this db attached from another instance or upgraded from 2k?

    I have had this problem - changing the owner is simple. What do you mean by it didn't work? It should be pretty easy e.g.
    Code:
    
    USE Mydb
    GO
     
    EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
    GO
    
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Thanks for the reply.
    Yes this database was restored from a backup taken from another machine. I fixed the orphaned user and changed the db owner to other user. but still the error persists. though i did not change sa owner.
    will try fixin the SA login.







    Quote Originally Posted by pootle flump
    Hi

    Was this db attached from another instance or upgraded from 2k?

    I have had this problem - changing the owner is simple. What do you mean by it didn't work? It should be pretty easy e.g.
    Code:
    
    USE Mydb
    GO
     
    EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
    GO
    

  5. #5
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Thanks a lot pootle flump.
    It worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •