Upgrading SCCM 2403 Secondary site

Seyed Majid Taheri 21 Reputation points
2024-06-05T05:54:32.6066667+00:00

I successfully upgraded SCCM to 2403. I'm trying to upgrade secondary sites, but I received the below error during the prerequisites check.

[Failed]:The logon account for the SQL Server service cannot be a local user account, NT SERVICE\<sql service name> or LOCAL SERVICE.  You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.

I used valid domain account but still I receive mentioned error.

how do I fix it?

 

Microsoft Configuration Manager
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 42,351 Reputation points Microsoft Vendor
    2024-06-05T07:22:58.51+00:00

    Hi, @Seyed Majid Taheri

    Thank you for posting in Microsoft Q&A forum.

    We may try to change the Service Startup Account follow this guidance:

    https://video2.skills-academy.com/en-us/sql/database-engine/configure-windows/scm-services-change-the-service-startup-account?view=sql-server-ver16#SSMSProcedure

    If the domain account still gets the error, we may try to use the LOCAL SYSTEM.

    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".

  2. Seyed Majid Taheri 21 Reputation points
    2024-06-05T12:26:41.64+00:00

    I received below error in ConfigMgrPrereq.log

    GetServiceAccount : Failed to get Service [MSSQL$CONFIGMGRSEC] start account on server [xyz.domain]. Win32 Error = 1727. Configuration Manager Prereq

    ERROR: Failed to get sql service account, Server:<xyz.domain>, instance:<CONFIGMGRSEC>. Configuration Manager Prereq

    I checked port 135 and it was ok but still I get error.

    0 comments
  3. AllenLiu-MSFT 42,351 Reputation points Microsoft Vendor
    2024-06-06T02:54:08.42+00:00

    Hi, @Seyed Majid Taheri

    The ConfigMgrPrereq.log shows that it failed to get the SQL service account with error code 1727. This error code indicates that the RPC server is unavailable.

    You should check if the RPC service is running on the server and that the firewall is not blocking the RPC traffic. You can also check if the SQL Server Browser service is running.

    You may check this link for more details:

    https://www.reddit.com/r/SCCM/comments/748j0g/moving_db_from_one_sql_server_to_another/