Configuring an existing SQL Server

If you have an existing installation of SQL Server Express, the PME Installer adds the instance that is required by PME.

If you have an existing installation of SQL Server Standard Edition, then rerun the SQL Server Setup wizard and follow the steps described in Installing a new SQL Server.

In most cases, fewer steps are required. The Instance Configuration page is slightly different, as noted below.

The Instance Configuration page:

  1. Enter a name in the Instance Name field, for example ION. (Do not use an underscore character ( _ ) within the instance name.)
  2. Click in the Instance ID field to automatically add your Instance name entry.

  3. Click Next.

    Any existing instance names appear in the Installed Instances area on the page. If Management Studio Tools have previously been installed, they are identified as the shared components SSMS, and Adv_SSMS.

Complete the remaining steps in the instance addition process and close the SQL Server Installation Center.

(Recommended) Set the SQL Server memory options. See Setting SQL Server memory options for more information.

For SQL Server 2016, 2017, and 2019, if SQL Server Management Tools need to be installed, click Install SQL Server Management Tools in the SQL Server Installation Center to launch the download page for their installation. Internet access is required.