none
SCCM upgrade to 1902 RRS feed

  • Question

  • Hi,

    I am on 1806 and trying to update to 1902. During pre-check, i am getting the below error message:

    [Failed]:Verifies that the site server computer account has administrative rights on the SQL Server and management point.

    Please advice.

    Monday, July 22, 2019 9:34 AM

Answers

  • Hi,

    If you have a SQL Server or Management Point role installed separately from the site server, you have to add the account machine of the site server in the local administrators group to the remote servers.

    On the separate server:

    1. Open the Server Manager.
    2. Click on Tools, Computer Management.
    3. Expand Local Users and Groups, click on Groups, double click on Administrators group.
    4. Click on Add button then Object types... > Select only Computers object type.
    5. Browse your site server with the hostname then confirm.

    Then try to launch again the prerequisites check for the 1902 version, for more details, check the ConfigMgrPrereq.log log file located on the C drive of your site server.

    Regards,

    SAAD Youssef

    ______

    Please remember to mark the replies as answer if they help, thank you!

    • Proposed as answer by SAAD Youssef Monday, July 22, 2019 1:53 PM
    • Marked as answer by KKarun Monday, August 19, 2019 10:04 AM
    Monday, July 22, 2019 1:52 PM

All replies

  • Kindly verify the user and the SCCM computer account are both local administrators on the SQL server

    If already done, reboot once and try again

    Check the security and system event logs looking for DNS, Kerberos or other machine account registration issues on Site server

    Monday, July 22, 2019 9:51 AM
  • Hi,

    1.In most cases, we can solve this error by adding the SCCM server name to the Local Administrators Server.
    Here is a guide to follow in order to make SCCM server local administrator in remote SQL server.

    2.Please also check the management point.  Finally, there could be some authentication problems that are not obvious.  Check the security and system event logs looking for DNS, Kerberos or other machine account registration issues, this is fairly common. Please refer to this.

    Hope it helps. Thanks for your time.

    Best regards,
    Simon Ren

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, July 22, 2019 9:57 AM
  • Hi,

    If you have a SQL Server or Management Point role installed separately from the site server, you have to add the account machine of the site server in the local administrators group to the remote servers.

    On the separate server:

    1. Open the Server Manager.
    2. Click on Tools, Computer Management.
    3. Expand Local Users and Groups, click on Groups, double click on Administrators group.
    4. Click on Add button then Object types... > Select only Computers object type.
    5. Browse your site server with the hostname then confirm.

    Then try to launch again the prerequisites check for the 1902 version, for more details, check the ConfigMgrPrereq.log log file located on the C drive of your site server.

    Regards,

    SAAD Youssef

    ______

    Please remember to mark the replies as answer if they help, thank you!

    • Proposed as answer by SAAD Youssef Monday, July 22, 2019 1:53 PM
    • Marked as answer by KKarun Monday, August 19, 2019 10:04 AM
    Monday, July 22, 2019 1:52 PM
  • The server is added in admin group. I have Always on.

    i am getting below error message in the ConfigMgrPrereq.log log file:

    ERROR:Can not get sql instance regkey.

    ERROR:Failed to get Sql edition, Sql Server:DB01\INSTANCE1, instance:.

    ERROR:Can not get sql instance regkey.

    ERROR:Failed to get Sql edition, Sql Server:DB02\INSTANCE2, instance:.

    Tuesday, July 23, 2019 4:08 AM
  • Tuesday, July 23, 2019 6:50 AM