Changing database owner SID

• Eliyahu

  Ten Centuries

  Points: 1071

  More actions

  August 15, 2018 at 3:03 pm

  #360320

  Are there negative implications if I change the database owner SID?
  I need to change the SID for installing a CLR assembly. Is there something I should check before doing that on a large production database?

• andreas.kreuzberg

  SSCertifiable

  Points: 6201

  More actions

  August 17, 2018 at 1:27 am

  #2002193

  Hi,
  you should try this in your test environment. I changed the database owner many times and nothing happend.
  But nobody knows your sql server and databases.
  What kind of user do you want to use? A sql user or windows user?
  Best regards,
  Andreas