SQL Server Installation on Windows

This article provides a step-by-step procedure for installing a new instance of SQL Server by using the SQL Server Setup Installation Wizard.

To install SQL Server 2019 – Step by Step procedure

STEP 1: Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.

SQL Server Setup

STEP 2: The Installation Wizard runs the SQL Server Installation Center. To create a new installation of SQL Server, select Installation in the left navigation area, and then select New SQL Server standalone installation or add features to an existing installation.

SQL Server installation
New SQL Server Installation

STEP 3: On the Product Key page, select an option to indicate whether you’re installing a free edition of SQL Server or a production version that has a PID key.
STEP 4: To continue, select Next.

SQL Server product key

STEP 5: On the License Terms page, review the license agreement. If you agree, select the I accept the license terms and privacy statement check box, and then select Next.

SQL server license terms

STEP 6: In the Global Rules page, Setup will automatically advance to the Product Updates page if there are no rule errors.
STEP 7: The Microsoft Update page will appear next if the Microsoft Update check box in Control Panel -> All Control Panel Items -> Windows Update -> Change settings isn’t selected. Selecting the Microsoft Update check box changes the computer settings to include the latest updates for all Microsoft products when you scan for Windows updates.
STEP 8: On the Product Updates page, the latest available SQL Server product updates are displayed. If no product updates are discovered, Setup doesn’t display this page and automatically advances to the Install Setup Files page.

SQL Server updates

STEP 9: On the Install Setup Files page, Setup provides the progress of downloading, extracting, and installing the Setup files. If an update for Setup is found and you specify to include it, that update will also be installed. If no update is found, Setup will automatically advance.
STEP 10: On the Install Rules page, Setup checks for potential problems that might occur while running Setup. If failures occur, select an item in the Status column for more information. Otherwise, select Next.

SQL Server verification

STEP 11: If this is the first installation of SQL Server on the machine, Setup skips the Installation Type page and goes directly to the Feature Selection page. If SQL Server is already installed on the system, you can use the Installation Type page to select either to perform a new installation or to add features to an existing installation. To continue, select Next.
STEP 12: On the Feature Selection page, select the components for your installation. For example, to install a new instance of SQL Server Database Engine, select Database Engine Services.

SQL Server Feature selection

STEP 13: The Feature Rules page automatically advances if all rules pass.

SQL Server root directory

STEP 14: On the Instance Configuration page, specify whether to install a default instance or a named instance.
Instance ID: By default, the instance name is used as the instance ID.
Installed instances: The grid shows the instances of SQL Server that are on the computer where Setup is running.

SQL Server named instance

STEP 15: Use the Server Configuration – Service Accounts page to specify the logon accounts for SQL Server services.

SQL Server Service accounts

STEP 16: You can choose a default collation for your SQL Server instance.

SQL Server collation

STEP 17: Use the Database Engine Configuration – Server Configuration page to specify the following options:
Security Mode: Select Windows Authentication or Mixed Mode Authentication for your instance of SQL Server.
SQL Server Administrators: You must specify at least one system administrator for the instance of SQL Server.

Server configuratioin

STEP 18: On Data Directories tab you can specify default directories for your data and log files. It is a good practice to separate system databases from user databases and put their data files and transaction log files on different drives.

Data directories

STEP 19: On the TempDB tab, you can configure the number, the size, and the location of TempDB data and transaction log files. Busy systems require many TempDB data files to avoid page contention. If you’re installing this instance just for yourself you can leave default settings.

sql server tempdb

STEP 20: On the Filestream tab, you can decide if you want to have the Filestream feature enabled. To continue, click the Next button.

sql server filestream

STEP 21: Install R as part of the Machine Learning Services, now you need to give your consent to download and install the Microsoft R Open. To do so, you have to click the Accept button, then you can click the Next button to continue.

sql server R Open

STEP 22: To install Python you also need to give your consent to download and install the Anaconda (python distribution). To do so, you have to click the Accept button, then you can click the Next button to continue.

sql server python

STEP 23: The Setup will check Feature Configuration rules. If any of these rules fail, you have to work on a solution. Otherwise, the installation will be stopped. If all checks successfully passed, click the Next button to continue.

sql server rules

STEP 24: The Ready to Install page is the last page before the installation process is started. Please review the Summary to finalize the selection. These configuration settings are also saved in configurationFile.ini. This file can be later used for unattended installation. To install SQL Server 2019 and all chosen features click the Install button.

sql server summary

STEP 25: Installation would take 10-15 minutes, depending on the server configuration.

sql server wait installation

STEP 26: Finally, when installation is Done, you may be prompted that additional computer restart is required. Click the OK button to confirm.

sql server successful installation

STEP 27: Post completion, you will be able to view the status of every status.

sql server installation completed

 

Published by Abdul Samad

Having 17+ years of extensive experience in IT industry, enabled to enhance the team performance and maximize customer satisfaction by strategically managing calls and implementing process improvements. Demonstrated ability to solve problems, meets challenging goals, and expedites delivery. Skilled MSSQL administrator guide team during the crisis situation. Apply Creative thoughts process in re-designing the workflow system to eliminate duplication of effort and increase productivity.

Leave a Reply