Forum Discussion
Solved
SQL Server 2019 CU22 (KB5027702) does not install correctly - crashes the server
Attempted to install SQL Server 2019 CU22 (KB5027702). Installation did not complete and I was unable to restart the database engine any more. Got the following error message: "SQL Server is in scri...
- Seems to come from here
Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
Please follow below link. it is mentioning another object related to Database Mail but it should apply for your case too
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-2714
Seems to come from here
Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
Please follow below link. it is mentioning another object related to Database Mail but it should apply for your case too
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-2714
Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
Please follow below link. it is mentioning another object related to Database Mail but it should apply for your case too
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-2714
Thank you for your help, this seems to be the solution.