79148141

Date: 2024-11-01 13:28:22
Score: 2.5
Natty:
Report link

so we ended up setting this server as the primary then updating the owner to the same SID as the main primary then resetting the primary back to the original one. If the owners dont match you get this error. Here are the two documents.

https://www.sqlskills.com/blogs/paul/the-curious-case-of-the-clr-assembly-failure-after-an-ag-failover/

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/development/error-run-clr-object-create-assembly

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
Posted by: Jed