Unable to upgrade SCCM to 2103

Vitor Verdura 96 Reputation points
2021-11-22T12:45:21.823+00:00

Hi,

I was trying to update SCCM from 1910 to 2103 but now in the "Update Pack Installation Status" the installation is in progress for several days. I already reboot several times, but no luck...
Here is the screenshot:

151426-1.png

And some logs with errors in the CMUpdate.log:
---

CONFIGURATION_MANAGER_UPDATE service is starting... CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
Microsoft Endpoint Configuration Manager v5.00 (Build 9049) CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
Process ID: 1088 CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
Worker thread ID: 1168 CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
Inbox source is local on DAMASCO.xxxxx.xxx CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
Set inbox to \DAMASCO.xxxxx.xxx\SMS_DAM\inboxes\cmupdate.box CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
This running on active site server DAMASCO.xxxxx.xxx. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
Inbox source is local on DAMASCO.xxxxx.xxx CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:03 1168 (0x0490)
*** [08001][2][Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:10 1168 (0x0490)
*** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:10 1168 (0x0490)
*** [42000][4060][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CM_DAM" requested by the login. The login failed. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:10 1168 (0x0490)
*** [08001][2][Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:10 1168 (0x0490)
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:10 1168 (0x0490)
ExecuteSqlCMUpdateInitScripts: Can't get SQL connection CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:10 1168 (0x0490)
Getting SYSCENTERID & iLicenseType CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:12 1168 (0x0490)
Initializing the status message reporting system... CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:12 1168 (0x0490)
Inbox source is local on DAMASCO.xxxxx.xxx CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:12 1168 (0x0490)
Waiting for SMS_INBOX_MANAGER to create the "Status Manager" inbox. Sleeping for 60 seconds. The operating system reported error 53: The network path was not found. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:21:14 1168 (0x0490)
Inbox source is local on DAMASCO.xxxxx.xxx CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:14 1168 (0x0490)
The path to the "Status Manager" inbox is "C:\Program Files\Microsoft Configuration Manager\inboxes\statmgr.box\statmsgs". CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:14 1168 (0x0490)
SMS_STATUS_MANAGER is not running as part of this process, the SMS_EXECUTIVE to SMS_STATUS_MANAGER in-memory status message queue will not be used. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:14 1168 (0x0490)
Registered this process as a source of "SMS Server" events. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:15 1168 (0x0490)
Registered this process as a source of "SMS Client" events. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:15 1168 (0x0490)
Registered this process as a source of "SMS Provider" events. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:15 1168 (0x0490)
Status message reporting system initialized successfully. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:15 1168 (0x0490)
There is no need to start monitoring thread. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:16 1168 (0x0490)
Waiting for changes to the "\DAMASCO.xxxxx.xxx\SMS_DAM\inboxes\cmupdate.box" directories, updates will be polled in 600 seconds... CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:22:16 1168 (0x0490)
There is no pending update package to be processed. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:32:17 1168 (0x0490)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:32:17 1168 (0x0490)
Waiting for changes to the "\DAMASCO.xxxxx.xxx\SMS_DAM\inboxes\cmupdate.box" directories, updates will be polled in 600 seconds... CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:32:17 1168 (0x0490)
There is no pending update package to be processed. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:42:17 1168 (0x0490)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:42:17 1168 (0x0490)
Waiting for changes to the "\DAMASCO.xxxxx.xxx\SMS_DAM\inboxes\cmupdate.box" directories, updates will be polled in 600 seconds... CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:42:17 1168 (0x0490)
There is no pending update package to be processed. CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:52:17 1168 (0x0490)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure CONFIGURATION_MANAGER_UPDATE 22/11/2021 09:52:17 1168 (0x0490)

---

Thanks a lot for all the help you can provide!

Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Amandayou-MSFT 11,046 Reputation points
    2021-11-23T03:05:24.353+00:00

    Hi @Vitor Verdura ,

    According to the information, it seems that the account 'NT AUTHORITY/SYSTEM' has not been added into the SQL.

    Please check if the account exists in the SQL sever management studio.

    151567-1123.png

    If not, please create the new login.

    151630-11231.png


    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 "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Vitor Verdura 96 Reputation points
    2021-11-23T13:53:21.557+00:00

    Hi @Amandayou-MSFT ,

    Thanks for the help!
    I've already have checked and it exists. I should have mentioned it... Sorry. Here it is the print screen:

    151892-2.png