Loading...

Upgrading Microsoft SQL Server 2014 Express to Microsoft SQL Server 2016 Standard Edition

Applies to: CommServe computer running Microsoft SQL Server Express

By default, the Microsoft SQL Server Express software is installed during the installation of some Commvault software (for example, the Edge solution).

Note:

Before You Begin

  • Create an installation package by using the Download Manager. The installation package must include the Microsoft SQL Server and the necessary Commvault server packages, such as the CommServe or Workflow Engine. For instructions about creating the package, see Downloading Software for Windows Computers Using the Download Manager.
  • Make sure that you have the Microsoft SQL Server Standard Edition software on the CommServe computer.
  • Perform a disaster recovery backup of your CommServe database. For more information, see Performing a Disaster Recovery Backup.

Procedure

  1. Disable CommCell activities as follows:
    1. From the CommCell Browser, right-click the CommServe node, and then click Properties.
    2. On the Activity Control tab, clear all the check boxes except the Enable All Job Activity check box, and then click OK.

      This ensures that no new jobs are performed, except for disaster recovery operations, VM provisioning jobs, and workflow jobs.

    3. From the Job Controller, kill all jobs that are in progress, or wait for the jobs to finish.
  2. Perform a disaster recovery (DR) backup as follows:
    1. From the CommCell Browser, right-click the CommServe node, and then click All Tasks > Disaster Recovery Backup.

      The Disaster Recovery Options dialog box appears.

    2. Click OK.

      The DR backup files are saved to the location specified in the DR Backup Settings dialog box that is available from the Control Panel. The DR backup includes the CommServe database dump file. By default, the dump file name is commserv.dmp.

  3. From the Commvault Process Manager on the CommServe computer, stop all Commvault Services.
  4. Find the installation package that you created using the Download Manager, navigate to <Download_Location>\<Download_Location>_WinX64\ThirdParty\MSSQL\SQL_Standard_Edition, and then double-click setup.exe.

    The Installation Wizard starts the SQL Server Installation Center.

  5. In the left-hand navigation area, click Installation , and then click Upgrade from... previous versions of SQL Server.

    On the Product Key page, the product key is pre-populated.

  6. Click Next.
  7. On the License Terms page, select the I accept the license terms check box, and then click Next.
  8. In the Global Rules window, the setup procedure will automatically advance to the Product Updates window if there are no rule errors.
  9. The Microsoft Update page will appear next if the Microsoft Update check box in Control Panel\All Control Panel Items\Windows Update\Change settings is not checked. Putting a check in the Microsoft Update page will change the computer settings to include the latest updates when you scan for Windows Update.
  10. On the Product Updates page, the latest available SQL Server product updates are displayed. If you don't want to include the updates, clear the Include SQL Server product updates check box. If no product updates are discovered, SQL Server Setup does not display this page and auto advances to the Install Setup Files page.
  11. On the Install Setup Files page, SQL Server Setup shows the progress of downloading, extracting, and installing the setup files. If an update for SQL Server Setup is found, and is specified to be included, that update will also be installed.
  12. In the Upgrade Rules window, the setup procedure will automatically advance to the Select instance window if there are no rule errors.
  13. On the Select Instance page, specify the instance of SQL Server to upgrade. To upgrade Management tools and shared features, select Upgrade shared features only.
  14. On the Select Features page, the features to upgrade will be preselected. After you select a feature name, a description for each component group appears in the right pane.

    The prerequisites for the selected features are displayed on the right pane. SQL Server Setup will install the prerequisite that are not already installed during the installation step described later in this procedure.

    Note: If you have opted to upgrade the shared features by selecting Upgrade shared features only on the Select Instance page, all the shared features are preselected on the Feature Selection page. All the shared components are upgraded at the same time.

  15. On the Instance Configuration page, specify the Instance ID for the instance of SQL Server.
  16. Instance ID. By default, the instance name is used as the Instance ID. This is used to identify installation directories and registry keys for your instance of SQL Server. This is the case for default instances and named instances. For a default instance, the instance name and instance ID would be MSSQLSERVER. To use a non-default instance ID, provide a value for the Instance ID textbox.

    All SQL Server service packs and upgrades will apply to every component of an instance of SQL Server.

    Installed instances. The grid will show instances of SQL Server that are on the computer where the SQL Server Setup is running. If a default instance is already installed on the computer, you must install a named instance of SQL Server.

    Note: Depending on the features that you have specified for your installation, you may not see all of the remaining options described in the following steps.

  17. On the Server Configuration - Service Accounts page, the default service accounts are displayed for SQL Server services. The actual services that are configured on this page depend on the features that you are upgrading.

    Authentication and login information will be carried forward from the previous instance of SQL Server. You can assign the same login account to all SQL Server services, or you can configure each service account individually. You can also specify whether services start automatically, are started manually, or are disabled. Microsoft recommends that you configure service accounts individually so that SQL Server services are granted the minimum permissions they have to have to complete their tasks.

    To specify the same login account for all service accounts in this instance of SQL Server, provide credentials in the fields at the bottom of the page.

  18. Click Next.
  19. On the Full-Text Search Upgrade Options page, specify the upgrade options for the databases being upgraded.
  20. The Feature Rules window will automatically advance if all rules pass.

    The Ready to Upgrade page displays a tree view of installation options that were specified during Setup.

  21. Click Install.

    After installation, the Complete page provides a link to the summary log file for the installation and other important notes.

  22. Click Close.
  23. Restart the computer if you are instructed to do so.

Last modified: 12/13/2019 4:25:22 PM