Installing SQL Server

The SQL Server server must be a member of the Active Directory domain.

  1. Run the SQL Server Installation Center.

  2. Select New SQL Server standalone installation.

  3. Enter the product key, then accept the license terms.

  4. If necessary, automatically download the latest Windows and SQL Server updates.

  5. After checking the Install rules, you will see a warning on the Windows firewall. You must configure it later to allow all SQL Server network traffic. For more information, see section Opening ports on the firewall.
    Installation rules window

  6. On the Feature selection screen, select Database engine services, and in the Instance root directory field, enter E:\MSSQL.

  7. On the Instance configuration screen, enter the following parameters:
    Named instance: ENDPOINTSECURITY
    Instance ID: ENDPOINTSECURITY

    Instance configuration window

  8. On the Server configuration screen, under the Service accounts tab, fill in the name of the account and the password for the SQL Server Account and SQL Server Database Engine services. The same account has been used for both services in this example, but you can dissociate them.

  9. The Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service option must be selected. For more information, refer to the related Microsoft documentation.
    Server configuration window

  10. In the Collation tab, select French_CI_AS. For more information, refer to the related Microsoft documentation.

  11. On the Database engine configuration screen, under the Server configuration tab, select Mixed mode and set a password for the sa account.
    The account needed for the installation will automatically be added to the instance.

  12. In the Data directories tab, spread out the database files as follows:

    • Data root directory: E:\MSSQL

    • Instance-specific binaries and libraries.

    • User database directory: E:\MSSQL\DATA

    • Data files (.mdf or ndf) for user databases.

    • User database log directory: F:\MSSQL\LOG

    • Log files (.ldf) for user databases.

    • Backup directory: G:\MSSQL\BACKUP
      Backup files

    • Database engine configuration window

  13. With regard to storage, follow the recommendations given below:

    • Do not install SQL Server on the C:\ drive with the operating system.
    • Do not store data files and log files on the same disk.
    • Isolate the backups of other files.

  14. In the TempDB tab, the tempDB database is configured by default with one data file per virtual processor. Do not exceed 8 files.
    • Data directory: H:\MSSQL\TEMPDBDATA
    • Log directory: The same as the one for user databases, F:\MSSQL\LOG
      Database engine configuration window - TempDB tab

    Follow the recommendations given below for tempDB:

    • For optimal performance and administration, isolate tempDB data files on a dedicated volume.

    • Do not store data files and log files on the same volume.

  15. In the Ready to install screen, click on Install. The SQL Server instance will start installing.