Skip to main content

ConfigMgr 2012 Service Pack Upgrade - Unsupported ConfigMgr database version

By
ConfigMgr 2012 Service Pack Upgrade
(SCCM 2012 R2 SP1 upgrade)

I was performing the initial Test Database command from the SMSSETUP\BIN\X64 directory of the installation media run the following command:
(Setup.exe /testdbupgrade <database_name> )

Once the Pre-requistite check runs it references 'Unsupported ConfigMgr database version' and log states 'Failed to connect to SQL Server to verify site version'.
If you search else where you may think this is a permissions based issue (definately check) but in my case this was not the case and i knew the database was supported.


===== INFO: Prerequisite Type & Server: SQL: =====
<<<RuleCategory: Database Upgrade Requirements>>>
<<<CategoryDesc: Checking the target ConfigMgr database is ready to upgrade...>>>
INFO: CheckTestDBVersion start ...
ERROR: Failed to connect to SQL Server to verify site version.
Unsupported ConfigMgr database version;    Error;    For the site database upgrade to succeed, the database version must be Configuration Manager 2012 R2 or later.
INFO: Start checking SQL Native Client 11.
INFO: SQL Native Client 11 is already installed on local machine.
Sql Server Native Client;    Passed
INFO: SQL Server computer <Name.Domain.COM>
INFO: SQL Server named instance <>
INFO: Cannot connect to registry key.


Resolution: It was an issue in the Syntax on the command line. It is quite common for the database name to resemble CM_P01 or CM_P02 etc.  However, in this case it was CM_PO1 and CM_P02 etc.
If you look closely there is a difference.  Check whether its a ZERO (0) or a letter O

Setup.exe /testdbupgrade <database_name>
Labels:

Comments

  1. AnonymousAugust 2, 2016 at 3:11 AM

    Yes, not a very intelligent bit of code behind this error evidently. It also means, as you discovered, "The specified database was not found".

    ReplyDelete
  2. Innocent MkSeptember 27, 2017 at 12:20 AM

    Locking or two-phase locking is a leading method for initiating concurrency control to facilitate the management of databases. kpi dashboards

    ReplyDelete
  3. Kavin cookOctober 23, 2017 at 4:39 AM

    Database security is done periodically by the administrator of the company's website for closely monitoring the activities of the users who have access to the database. create dashboard for oracle

    ReplyDelete

Post a Comment

Popular posts from this blog

SCCM Unknown computer not able to see Task Sequences after installing Current Branch 1702

By
Soon after installing SCCM CB 1702 we were unable to see Task Sequences deployed to the unknown collection. This issue was identified as a random system taking the GUID of the 'x64 Unknown Computer (x64 Unknown Computer)' record. As a result it was now a known GUID; as we were only deploying Task Sequences to the Unknown collection none were made available. 'x64 Unknown Computer (x64 Unknown Computer)' record 'x86 Unknown Computer (x86 Unknown Computer)' record To get the GUID of your unknown systems open SQL management studio and run the following command: --Sql Command to list the name and GUID for UnknownSystems record data select ItemKey, Name0,SMS_Unique_Identifier0 from UnknownSystem_DISC Using the returned GUID (SMS_Unique_Identifier0) we can find the hostname that has been assigned the 'x64 Unknown Computer (x64 Unknown Computer)' GUID by running the query below. --x64 Unknown Computers select Name0,SMS_Unique_Identifier0,Decommissioned0 from Sys...
167 comments
Read more

KB5025885: How to manage the Windows Boot Manager revocations for Secure Boot changes associated with CVE-2023-24932

By
This article outlines the protection against the publicly disclosed Secure Boot security feature bypass involving the BlackLotus UEFI bootkit (CVE-2023-24932). It includes steps to enable the necessary mitigations and provides guidance on creating bootable media. I will provide: - An overview of the CVE issue. - Pre-requisite actions within ADK. - Detection and remediation scripts for CVE-2023-24932. - Instructions for creating a WinPE Boot.wim file to support systems that have undergone remediation. - A breakdown of the files changed and how to boot WinPE to support systems before remediation. 1. Secure Boot Security Feature Bypass Vulnerability CVE-2023-24932 see MSRC CVE-2023-24932 is a security vulnerability involving the BlackLotus UEFI bootkit, which allows attackers to bypass Secure Boot protections. This vulnerability enables the execution of malicious code at the UEFI level, potentially leading to persistent and evasive threats. Mitigations for this issue include updates to th...
Post a Comment
Read more

Blackberry How to factory reset your device.

By
Here's how to FACTORY RESET the device. Install Blackberry Desktop Manager on a PC.  Connect the Blackberry to the PC with a USB cable. From a DOS prompt (command) window on the users PC (from Start - Run  type cmd <OK>  then change directory path to: C:\Program Files\Common Files\Research In Motion\Apploader     by typing cd\ (enter)  followed by cd Program Files (enter) then cd Common Files (enter)  etc etc Run the command:   Loader.exe /resettofactory That will bring the Blackberry back to the state it should be in when you get a brand new one out of the box.
Post a Comment
Read more