none
InPlace Upgrade from SCCM 2012 SP2 to SCCM 1702

    Question

  • Hi All,

    I have go through the checklist for upgrade SCCM 2012 R2 to SCCM 1702, So I have tried to(Test the site database upgrade) 

    testDBupgrade by restore the site database to test machine but while I run the testdbupgrade on command line , I have received below error could any suggest what could be the problem

    Attaching the logs for same please suggest

    <03-23-2018 13:14:18> ********************************************
    <03-23-2018 13:14:18> ******* Start Prerequisite checking. *******
    <03-23-2018 13:14:18> ********************************************
    <03-23-2018 13:14:18> INFO: Executing prerequisite functions...
    <03-23-2018 13:14:18> ===== INFO: Prerequisite Type & Server: SQL: =====
    <03-23-2018 13:14:18> <<<RuleCategory: Database Upgrade Requirements>>>
    <03-23-2018 13:14:18> <<<CategoryDesc: Checking the target ConfigMgr database is ready to upgrade...>>>
    <03-23-2018 13:14:18> INFO: CheckTestDBVersion start ...
    <03-23-2018 13:14:18> ERROR: Failed to connect to SQL Server to verify site version.
    <03-23-2018 13:14:18> ;    Unsupported ConfigMgr database version;    Error;    For the site database upgrade to succeed, the database version must be Configuration Manager 2012 R2 or later.
    <03-23-2018 13:14:18> INFO: Start checking SQL Native Client 11.
    <03-23-2018 13:14:18> INFO: SQL Native Client 11 is already installed on local machine.
    <03-23-2018 13:14:18> ;    Sql Server Native Client;    Passed

    Configuration Setup

    <03-23-2018 13:14:12> *********************************************
    <03-23-2018 13:14:12> *****   ConfigMgr Setup Bootstrapper    *****
    <03-23-2018 13:14:12> *********************************************
    <03-23-2018 13:14:12> Commandline:
    <03-23-2018 13:14:12> "SetupWpf.exe"  /TESTDBUPGRADE EDSCCMTEST02/CM_EDN
    <03-23-2018 13:14:12> INFO: Checking dotnet framework versions...
    <03-23-2018 13:14:12> INFO: Dotnet 3.5 installed
    <03-23-2018 13:14:12> Starting SetupWpf.exe...
    ~~===================== << Starting Configuration Manager 2012 Setup >> =====================  $$<Configuration Manager Setup><03-23-2018 13:14:17.011+420><thread=2888 (0xB48)>
    INFO: ConfigMgr2012 Setup was started by COMMERCEDESK\sa_punemand.  $$<Configuration Manager Setup><03-23-2018 13:14:17.121+420><thread=2888 (0xB48)>
    INFO: Command line specified was: "SetupWpf.exe"  /TESTDBUPGRADE EDSCCMTEST02/CM_EDN  $$<Configuration Manager Setup><03-23-2018 13:14:17.136+420><thread=2888 (0xB48)>
    ~FQDN for server EDSCCMTEST02 is Client machine  $$<Configuration Manager Setup><03-23-2018 13:14:17.183+420><thread=2888 (0xB48)>
    INFO: Target computer is a 64 bit operating system.  $$<Configuration Manager Setup><03-23-2018 13:14:17.340+420><thread=2888 (0xB48)>
    INFO: Checking for existing setup information.  $$<Configuration Manager Setup><03-23-2018 13:14:17.340+420><thread=2888 (0xB48)>
    INFO: Checking for existing SQL information.  $$<Configuration Manager Setup><03-23-2018 13:14:17.355+420><thread=2888 (0xB48)>
    INFO: Verifying the registry entry for Asset Intelligence installation  $$<Configuration Manager Setup><03-23-2018 13:14:17.355+420><thread=2888 (0xB48)>
    INFO: Setting the default CSV folder path  $$<Configuration Manager Setup><03-23-2018 13:14:17.371+420><thread=2888 (0xB48)>
    INFO: No language packs detected.  $$<Configuration Manager Setup><03-23-2018 13:14:17.371+420><thread=2888 (0xB48)>
    INFO: Configuration Manager Build Number = 8412  $$<Configuration Manager Setup><03-23-2018 13:14:17.621+420><thread=2888 (0xB48)>
    INFO: Configuration Manager Version = 5.0  $$<Configuration Manager Setup><03-23-2018 13:14:17.636+420><thread=2888 (0xB48)>
    INFO: Configuration Manager Minimum Build Number = 800  $$<Configuration Manager Setup><03-23-2018 13:14:17.636+420><thread=2888 (0xB48)>
    INFO: Verifying Configuration Manager Active Directory Schema Extensions.  $$<Configuration Manager Setup><03-23-2018 13:14:17.636+420><thread=2888 (0xB48)>
    INFO: Found DS Root:CN=Schema,CN=Configuration,DC=commercedesk,DC=com~  $$<Configuration Manager Setup><03-23-2018 13:14:17.855+420><thread=2888 (0xB48)>
    INFO: Verifying Configuration Manager Active Directory Schema Extensions.  $$<Configuration Manager Setup><03-23-2018 13:14:17.855+420><thread=2888 (0xB48)>
    INFO: Found DS Root:CN=Schema,CN=Configuration,DC=commercedesk,DC=com~  $$<Configuration Manager Setup><03-23-2018 13:14:17.871+420><thread=2888 (0xB48)>
    Setup Command Line is "SETUPWPF.EXE"  /TESTDBUPGRADE EDSCCMTEST02/CM_EDN  $$<Configuration Manager Setup><03-23-2018 13:14:17.886+420><thread=2888 (0xB48)>
    Setup Type is 0  $$<Configuration Manager Setup><03-23-2018 13:14:17.886+420><thread=2888 (0xB48)>
    INFO: Command line options being used are /TESTDBUPGRADE EDSCCMTEST02/CM_EDN   $$<Configuration Manager Setup><03-23-2018 13:14:17.886+420><thread=2888 (0xB48)>
    INFO: the install path is set to temp folder: C:\Users\SA_PUN~1\AppData\Local\Temp\SCCM.  $$<Configuration Manager Setup><03-23-2018 13:14:17.902+420><thread=2888 (0xB48)>
    INFO: SqlInstName = Default Instance  $$<Configuration Manager Setup><03-23-2018 13:14:17.902+420><thread=2888 (0xB48)>
    Removed SQL alias Client machine successfully.  $$<Configuration Manager Setup><03-23-2018 13:14:18.074+420><thread=2888 (0xB48)>
    INFO: Registered type Client machine MASTER for Client machine master  $$<Configuration Manager Setup><03-23-2018 13:14:18.090+420><thread=2888 (0xB48)>
    INFO: Registered type SMS Master for Client machine master  $$<Configuration Manager Setup><03-23-2018 13:14:18.105+420><thread=2888 (0xB48)>
    INFO: Registered type Client machine EDSCCMTEST02/CM_EDN for Client machine EDSCCMTEST02/CM_EDN  $$<Configuration Manager Setup><03-23-2018 13:14:18.105+420><thread=2888 (0xB48)>
    INFO: Registered type SMS ACCESS for Client machine EDSCCMTEST02/CM_EDN  $$<Configuration Manager Setup><03-23-2018 13:14:18.121+420><thread=2888 (0xB48)>
    INFO: Testing SQL Server database upgrade on EDSCCMTEST02/CM_EDN database, on the Client machine server.  $$<Configuration Manager Setup><03-23-2018 13:14:18.121+420><thread=2888 (0xB48)>
    INFO: SQL Connection succeeded. Connection: Client machine MASTER, Type: Unsecure  $$<Configuration Manager Setup><03-23-2018 13:14:18.480+420><thread=2888 (0xB48)>
    INFO: SQL Server Client machine is not clustered.  $$<Configuration Manager Setup><03-23-2018 13:14:18.496+420><thread=2888 (0xB48)>
    INFO: SQL Connection succeeded. Connection: Client machine MASTER, Type: Unsecure  $$<Configuration Manager Setup><03-23-2018 13:14:18.496+420><thread=2888 (0xB48)>
    INFO: SQL Always On is NOT enabled in this environment.  $$<Configuration Manager Setup><03-23-2018 13:14:18.511+420><thread=2888 (0xB48)>
    INFO: Attempting to load resource DLL...  $$<Configuration Manager Setup><03-23-2018 13:14:18.527+420><thread=2888 (0xB48)>
    *** [42000][4060][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "EDSCCMTEST02/CM_EDN" requested by the login. The login failed.  $$<Configuration Manager Setup><03-23-2018 13:14:18.761+420><thread=2216 (0x8A8)>
    *** [42000][4060][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "EDSCCMTEST02/CM_EDN" requested by the login. The login failed.  $$<Configuration Manager Setup><03-23-2018 13:14:18.777+420><thread=2216 (0x8A8)>
    *** Failed to connect to the SQL Server, connection type: SMS ACCESS.  $$<Configuration Manager Setup><03-23-2018 13:14:18.793+420><thread=2216 (0x8A8)>
    INFO: Canceling TestDBUpgrade  $$<Configuration Manager Setup><03-23-2018 13:26:09.743+420><thread=2888 (0xB48)>
    <03-23-2018 13:26:10> Failed to create process of SetupWpf.exe. return value 1

     

    Friday, March 23, 2018 8:30 PM

Answers

  • Instance name is not correct which has been fixed by changes instance name
    • Marked as answer by Pmandyal Wednesday, March 28, 2018 3:31 PM
    Wednesday, March 28, 2018 3:31 PM

All replies