locked
InPlace Upgrade from SCCM 2012 SP2 to SCCM 1702 RRS feed

  • 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

  • From the log above: "Cannot open database "EDSCCMTEST02/CM_EDN""

    You've either specified the wrong instance, server, or database name or the database is not properly mounted.


    Jason | https://home.configmgrftw.com | @jasonsandys

    Saturday, March 24, 2018 1:39 AM
  • Hi,

    Is the current user  the SQL service account specified when the SCCM was installed?

    What is the current version of the SQL server?
    It should be at least 2012 SP3 for 1702:
    https://docs.microsoft.com/en-us/sccm/core/plan-design/configs/support-for-sql-server-versions.


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

    Monday, March 26, 2018 10:27 AM
  • 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