Recommended SQL Server install options

When you install SQL Server, we recommend the following minimum required features. The exact configuration of SQL Server is unique to your specific plant scenario and requirements.

The following recommended options do not represent an installation sequence. They are highlights points during the install process, which can proceed in multiple ways.

• On the Feature Selection screen, ensure that these features are selected:

  • Database Engine Services

  • Reporting Services - Native

  • SQL Client Connectivity SDK

    

• On the Instance Configuration screen, keep the Default instance selection, unless you want to name you SQL Server instance.

  

• On the Server Configuration screen, accept or select the following:

  Service Accounts tab: The default service accounts, unless you want to configure your service accounts.
  

  • Collation tab: The case-insensitive SQL collation. Use the same collation for your SQL Server and AVEVA Production Management databases

    

• On the Database Engine Configuration screen, Server Configuration tab, do these:

  • Keep the default selection (Windows authentication mode). This is recommended, unless you want to enable SQL Server authentication.

  • Add SQL Server administrators. Add any users who require administrative access to the SQL Server.

    

• Take note of the log file path during the installation. You may need to check the log files in the future.

• Install the latest service packs and start the SQL service.