Install SQL Server 2022

The SQL Server Installation Wizard guides you through the steps required to install SQL Server 2022.

Upgrading to SQL Server 2022 is supported only after installing V15.2 Rev E, and 2024R1.

SQL Server Reporting Services

In SQL Server 2022, the Reporting Services is a separately installed feature. If required, install the Reporting Services according to Microsoft guidelines, on a local SQL Server hosting the reporting database server role. The server can be one of the following based on deployment level:

  • L1: Consolidated Server

  • L2: Data Center Server

  • L3: Database Server

  • L4/L5: Framework Database & Reporting Server

  • L6: Reporting Server

See  Install SQL Server Reporting Services (2022 and later) on Microsoft Site:

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-server-ver16

Procedure 

  1. Run Setup

    1. Insert the SQL Server installation media into the DVD drive.

    2. Open the drive and run setup.exe.

  2. Installation Type

    Select Installation, and select New SQL Server stand-alone installation or add features to an existing installation.

  3. Server Configuration > Services Accounts tab.

    1. For each service, enter the Account Name and Password.

    2. Configure the Startup Type for the following services:

      Service

      Startup Type

      SQL Server Agent

      Automatic

      SQL Server Database Engine

      Automatic

      SQL Server Integration Services

      N/A (not used by the system)

      SQL Server Browser

      N/A (not used by the system)

    3. Select the Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service option.

      SQL Services Account Requirements: SQL services account definition requirements are listed in the (Technology, Security, & Network Integration Deployment Reference Guide).

      SQL Server Installation on domain controllers: If you are installing SQL Server on the domain controller, refer to limitations outlined in the (Technology, Security, & Network Integration Deployment Reference Guide).

      Service account configurations for remote or cluster SQL servers: see Configure remote SQL Server.

  4. Server Configuration > Collation tab.

    The following instructions configure Windows collations as specified in the SQL collation requirements (Technology, Security, & Network Integration Deployment Reference Guide).

    For databases that are migrated from a system with SQL collation, you may be required to configure SQL collation on your target system. Contact your project manager for guidance.

    1. For the Database Engine, click Customize, and select Windows collation designator and sort order.

    2. Define the collation using these guidelines:

      • Collation designator: Set the collation as specified in the Site Preparation Checklist (SPC), or according to your database administrator.

      • Case-sensitive: Leave unselected.

      • Accent-sensitive: Set as specified in the Site Preparation Checklist (SPC), or according to your database administrator.

      • Leave the remaining options (Binary, Binary-code point, Kana-sensitive, Width-sensitive) clear (not selected). If there is a specific reason to select one of these options, consult your database administrator.

    3. Click OK, and then click Next.

  5. Database Engine Configuration > Server Configuration

    1. For Verint customers: Under Authentication Mode, click Windows Authentication Mode. Mixed mode is also supported.

    2. For British Telecom (BT) customers: 

      1. Under Authentication Mode, click Mixed Mode.

      2. Under Mixed Mode, specify the password for the SQL Server system administrator (sa) account.

    3. For IPC customers: Under Authentication Mode, click Mixed Mode.

    4. Under Specify SQL Server administrators, click Add, and then select the Database Management Account.

  6. Database Engine Configuration > Data Directories

    No updates are required on this tab.

  7. License Terms

    Accept the license terms, and click Next.

  8. Microsoft Update

    Leave the settings unselected, and click Next.

  9. Product Updates

    Leave the settings unselected, and click Next.

  10. Install Rules

    Verify that all rules have a status of Passed, and click Next.

  11. Feature Selection

    (The feature list may change for different SQL Server editions.)

    1. Select the Instance Features:

      • Database Engine Services

      • Integration Services

      • Full-Text and Semantic Extractor for Search

        This feature is only required to support Full-Text Search in the system. The Database Server must meet the Full-Text Search hardware requirements.

    2. If required, change the following directories:

      • Instance root directory

      • Shared feature directory

      • Shared feature directory (x86)

    3. Click Next.

  12. Feature Rules

    1. Wait for the operation completed message, and then click Show Details.

    2. Verify that all rules have a status of Passed, and click Next.

  13. Instance Configuration

    1. Select one of the following:

      • Default Instance: you can have one default instance for each machine. The default instance name is MSSQLServer.

      • Named Instance: you can set a named instance, such as (such as WFO or Recorder) in place of the default name, or if there are multiple instances on the same machine.

        For security reasons, use Named Instance as a best practice.

        Follow Microsoft's guidelines when defining the Named Instance, and ensure that it:

        - Begins with a letter.

        - Does not include more than 16 characters.

        Setting a named instance automatically adds the instance name to SQLServerAgent (computer name) and to MSSQL Service as follows:

        - SQLServerAgent: SQLAgent$<instance name>

        - MSSQL Service: MSSQL$<instance name>

    2. Instance Root Directory: Use the default path; change only if needed.

  14. Server Configuration > Services Accounts tab.

    1. For each service, enter the Account Name and Password.

    2. Configure the Startup Type for the following services:

      Service

      Startup Type

      SQL Server Agent

      Automatic

      SQL Server Database Engine

      Automatic

      SQL Server Integration Services

      N/A (not used by the system)

      SQL Server Browser

      N/A (not used by the system)

    3. Select the Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service option.

      SQL Services Account Requirements: SQL services account definition requirements are listed in the (Technology, Security, & Network Integration Deployment Reference Guide).

      SQL Server Installation on domain controllers: If you are installing SQL Server on the domain controller, refer to limitations outlined in the (Technology, Security, & Network Integration Deployment Reference Guide).

      Service account configurations for remote or cluster SQL servers: see Configure remote SQL Server.

  15. Server Configuration > Collation tab.

    The following instructions configure Windows collations as specified in the SQL collation requirements (Technology, Security, & Network Integration Deployment Reference Guide).

    For databases that are migrated from a system with SQL collation, you may be required to configure SQL collation on your target system. Contact your project manager for guidance.

    1. For the Database Engine, click Customize, and select Windows collation designator and sort order.

    2. Define the collation using these guidelines:

      • Collation designator: Set the collation as specified in the Site Preparation Checklist (SPC), or according to your database administrator.

      • Case-sensitive: Leave unselected.

      • Accent-sensitive: Set as specified in the Site Preparation Checklist (SPC), or according to your database administrator.

      • Leave the remaining options (Binary, Binary-code point, Kana-sensitive, Width-sensitive) clear (not selected). If there is a specific reason to select one of these options, consult your database administrator.

    3. Click OK, and then click Next.

  16. Database Engine Configuration > Server Configuration

    1. For Verint customers: Under Authentication Mode, click Windows Authentication Mode. Mixed mode is also supported.

    2. For British Telecom (BT) customers: 

      1. Under Authentication Mode, click Mixed Mode.

      2. Under Mixed Mode, specify the password for the SQL Server system administrator (sa) account.

    3. For IPC customers: Under Authentication Mode, click Mixed Mode.

    4. Under Specify SQL Server administrators, click Add, and then select the Database Management Account.

  17. Database Engine Configuration > Data Directories

    No updates are required on this tab.

  18. Database Engine Configuration > TempDB

    Modify/Set the Data directory and Log directory fields for TempDB according to the requirements specified in the Customer Furnished Equipment (CFE) Guide.

  19. Feature Configuration Rules

    The rule check runs automatically and when completed the Ready to Install page appears. Click Next.

  20. Ready to Install

    1. Verify that the settings for Prerequisites, General Configuration, and Instance Configuration are correct.

    2. If needed, click Back to access the settings you want to change.

    3. Click Install.

  21. Installation Progress

    Monitor the progress of the installation.

  22. Complete

    Do the following:

    1. Verify that each feature shows a status of Succeeded.

    2. Click Close.