MSDN > SQL Server > Installation > Standard Edition

SQL Server Standard Edition Installation Guide

This guide provides detailed instructions for installing SQL Server 2022 Standard Edition on your Windows or Linux environment. Standard Edition offers robust database capabilities for departmental applications and small to medium-sized data warehouses.

System Requirements

Before proceeding with the installation, ensure your system meets the following minimum requirements:

Component	Requirement
Operating System	Windows Server 2019 or later, Windows 10 (64-bit) or later, Red Hat Enterprise Linux 8+, SUSE Linux Enterprise Server 12+
Processor	x64 Processor (1.4 GHz or faster recommended)
Memory	Minimum 1 GB RAM (4 GB recommended for production environments)
Hard Disk Space	Minimum 6 GB (dependent on installed features)
.NET Framework	4.6.2 or later

Installation Steps (Windows)

Follow these steps to install SQL Server Standard Edition on a Windows operating system.

1. Download SQL Server Media

Download the SQL Server 2022 Standard Edition ISO file from the official Microsoft Download Center.

2. Run the Setup Program

Mount the ISO file and run setup.exe.

> setup.exe

3. Choose Installation Type

Select New SQL Server stand-alone installation or add features to an existing installation.

4. Enter Product Key

Enter your SQL Server Standard Edition product key. You can also choose to install an evaluation version.

5. Accept License Terms

Review and accept the license terms.

6. Select Features

Choose the components you wish to install. For a basic installation, select Database Engine Services. You can also select other features like Analysis Services, Reporting Services, or Integration Services as needed.

7. Instance Configuration

Specify a Named instance or use the Default instance. A named instance is recommended if you plan to install multiple SQL Server instances on the same machine.

Note: The default instance name is MSSQLSERVER. If you choose a named instance, remember its name for future connections.

8. Server Configuration

Configure service accounts for SQL Server Agent and the Database Engine. Use domain accounts for production environments for better security and manageability.

9. Database Engine Configuration

Choose the authentication mode:

Windows authentication mode: Recommended for most scenarios.
Mixed Mode (SQL Server authentication and Windows authentication): Requires setting a strong password for the sa (system administrator) account.

Add the current user or specify other Windows users/groups to have administrative privileges.

10. Ready to Install

Review the summary of your selections and click Install.

Installation Steps (Linux)

To install SQL Server Standard Edition on Linux, follow these general steps. Refer to the official documentation for specific distribution commands.

1. Install SQL Server Package

Use your distribution's package manager (e.g., yum, apt-get) to install the SQL Server package.

# For RHEL/CentOS
            sudo yum install mssql-server

            # For Ubuntu
            sudo apt-get install mssql-server

2. Run the Setup Script

Execute the setup script, which will prompt you to set the SA password and choose the edition.

sudo /opt/mssql/bin/mssql-conf setup

During the setup, you will be prompted to enter the SA password and select the edition. Choose Standard when prompted.

3. Verify Installation

Check the status of the SQL Server service.

sudo systemctl status mssql-server

Post-Installation Tasks

After a successful installation, consider performing the following tasks:

Install SQL Server Management Studio (SSMS) for Windows or Azure Data Studio for cross-platform management.
Configure firewall rules to allow remote connections if necessary.
Perform security hardening and backup configurations.

Important Considerations

Always refer to the official Microsoft SQL Server documentation for the most up-to-date and detailed information, including specific command-line options and advanced configurations.

SQL Server Docs