Table of Contents

SQL Server Installation

Please follow the instructions below to install the SQL Server software

Prepare SQL Setup

  • Download the SQL Server 2022 iso as zip file here
  • Mount this iso file
  • Run the setup

SQL Installation Center

  • Select New SQL Server Standalone installation or add features to an existing installation
  1. Product Key
  • Leave Product Key as is
  • Click Next
  1. Licence Terms
  • Check Accept the License terms
  • Click Next
  1. Microsoft Update
  • Check Use Microsoft Update to check for updates (recommended)
  • Click Next
  1. Install rules
  • Wait until the operation is completed
  • Click Next
  1. Feature Selection
  • Select Database Engine Service and Full-Text and Semantic Extractions for Search
  • Click Next
  1. Instance Configuration
  • Leave it as is
  • Click Next
  1. Server Configuration
  • Select tab Service Account
    • Only for the SQL Server Agent: change the Startup Type to Automatic
    • Check Gant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service
  • Select tab Collation
    • Click on Customize
    • Select Windows collation designator and sort order
    • Change Callation designator to Latin1_General_100
    • Only check Accent-sensitive
    • Click on OK
  • Click Next
  1. Database Engine Configuration
  • Select tab Server Configuration
    • Select Mixed Mode (SQL Server authentication and Windows Authentication)
    • Enter and confirm a password
    • Click on the button Add Current User
    • Click on the button Add and add the Boltrics user account in the popup-window
  • Select tab Data Directories

    IMPORTANT: Use different drive letters for each directory

    • Specify the same directory for Data root directory and User database directory
    • Specify a User database log directory for SQL database log files
    • Specify a Backup directory for SQL backup files
  • Select tab TempDB
    • Change the Initial size (MB) to 1024 for both fields
    • Change the Data directories to the same folder as the User database directory in the previous step
    • Change the Log directories to the same folder as the User database log directory in the previous step
  • Select tab Memory
    • Select Recommended
    • Check Click here to accept the recommended memory configurations for the SQL Server Database Engine
  • Click Next
  1. Ready to Install
  • Click Install
Important

  • Stay up-to-date with a recent cumulative updates

  • Please check the SQL Server exclusion list for your Virus Scanner here

  • Customer Responsibility:

    • Setup and management of the maintenance plans
    • SQL Database Backup
    • Rebuilding indexes and statistics
    • Use a linear grow of 4 GB of the databases, starting from 4GB for DATA and 2GB for LOG.
Important

Data file and log file configuration
Auto-growth of the database and/or transaction log files in production can degrade performance as all transaction must queue up and wait for SQL Server to grow the file before it can begin to process transactions again. This can create bottlenecks. We strongly recommend growing data and log files during off-peak periods and by 10% to 25% of the current size. We do not recommend disabling [Auto-Grow], as in an emergency it is still better to have SQL Server to auto-grow files than to run out of disk space and bring the database down.

Edit this page