SCCM 2309 upgrade failure

Question

We are trying to upgrade our site from 2303 with the latest hotfix to 2309 but the installation fails. The database is located on the same server. It is the only site system.

In the cmupdate.log we first see these errors, but the upgrade seems to carry on

*** [08S01][109][Microsoft][ODBC Driver 18 for SQL Server]Communication link failure

ERROR: Failed to create assembly ServiceBrokerInterface.

ERROR: Failed to UPDATE CLR assemblies.

Failed to update database.

Then later on we see these errors and the upgrade fails at this point

Failed to apply update changes 0x87d20b15

Error information persisted in the database.

I have verified that the SQL server, even though local, is set to allow remote connections, that SYSTEM does have sysadmin priv and that the memory allocations in SQL are the default values.

Answer 1

Hi, @Daniel Kaliel

Thanks very much for your feedback. We're glad that the problem is solved now. Here's a short summary for the problem, we believe this will help other users to search for useful information more quickly.

Problem/Symptom:

Upgrade SCCM from 2303 to 2309 but the installation fails, and get the error messages in cmupdate.log:

*** [08S01][109][Microsoft][ODBC Driver 18 for SQL Server]Communication link failure

ERROR: Failed to create assembly ServiceBrokerInterface.

ERROR: Failed to UPDATE CLR assemblies.

Failed to update database.

Solution/Workaround:

Install the ODBC driver 18 on every node that has the site system role installed.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click ""Add Comment".

Answer 2

Hi, @Daniel Kaliel

Thank you for posting in Microsoft Q&A forum.

Have we download and install Microsoft ODBC Driver 18 for SQL Server (x64) before upgrade?

https://www.prajwaldesai.com/fix-sql-client-prerequisite-missing-for-sccm/

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Answer 3

Hi everyone

I have the same problem however I installed the Microsoft ODBC Driver 18 for SQL Server (x64) before the upgrade but I still get that error

*** [08S01][109][Microsoft][ODBC Driver 18 for SQL Server]Communication link failure CONFIGURATION_MANAGER_UPDATE 11/19/2023 3:43:39 PM 7480 (0x1D38)

ERROR: Failed to create assembly ServiceBrokerInterface.

ERROR: Failed to UPDATE CLR assemblies.

Failed to update database. CONFIGURATION_MANAGER_UPDATE 11/19/2023 3:43:39 PM 7480 (0x1D38)