Patch upgrade failed. ‘Error:574 CONFIG statement cannot be used inside a user transaction.’


 

Customer failed to apply patch. SQL Service cannot start. They received below errors in SQL Error logs.

 

2020-11-24 20:09:21.59 spid5s      Configuration option ‘show advanced options’ changed from 1 to 1. Run the RECONFIGURE statement to install.
2020-11-24 20:09:21.59 spid5s      Error: 574, Severity: 16, State: 0.

2020-11-24 20:09:21.59 spid5s      CONFIG statement cannot be used inside a user transaction.

2020-11-24 20:09:21.59 spid5s      Error: 912, Severity: 21, State: 2.

2020-11-24 20:09:21.59 spid5s      Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered error 574, state 0, severity 16. This is a serious error condition which might interfere with regular operation