Installing SQL Server

The Advanced Store solution supports both Microsoft SQL Server 2016 and Microsoft SQL Server 2017. Install SQL Server according to Microsoft recommendations and in adherence with your company’s corporate policies. SQL Server can be installed as a new installation or as an upgrade.

When installing SQL Server, consider the following best practices:

  • Run separate SQL Server services under separate Windows accounts.
  • Run SQL Server services with the lowest possible privileges.
  • Associate SQL Server services with Windows accounts.
  • Require Windows Authentication for connections to SQL Server.

Prerequisites

If SQL Server will be installed as an upgrade, verify that the Compatibility Level of the ProductDB database matches the version of SQL Server being installed.

Note

The Compatibility Level can be verified by checking the database properties.

Installation

Select the following installation options:

  • Run the SQL Server installation program as an Administrator.
  • When installing SQL Server 2016, select the following Features:
    • Instance Features > Database Engine Services > SQL Server Replication.
    • All Shared Features, including Client Tools Connectivity.
  • When installing SQL Server 2017, select the following Features:
    • Instance Features > Database Engine Services
    • For Shared Features, select the following:
      • Client Tools Connectivity
      • Client Tools Backwards Compatibility
      • Client Tools SDK
  • SQL Server can be installed as a default instance or as a named instance.
    Note

    The default instance is the server name.

  • On the Server Configuration window, select a Startup Type of Automatic for each Service Account.
  • Install SQL Server using Mixed Mode Authentication.
  • Enabling User Instances is not required but can be enabled if required by the customer.
  • When upgrading from SQL Server 2016 to SQL Server 2017, Reporting Services will be uninstalled and will be a separate feature. Before updating, migrate reports to the new Reporting Services. Advanced Store doesn’t support the Reporting Services feature.
  • When upgrading, use the Full-Text Search Upgrade Options to select the full-text search upgrade option for the databases that are to be upgraded.
Note

If a previous copy of SQL Server Management Studio (SSMS) doesn’t exist on this machine, it can be downloaded and installed separately.