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.
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.
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.
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.
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.
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.
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.
STEP 13: The Feature Rules page automatically advances if all rules pass.
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.
STEP 15: Use the Server Configuration – Service Accounts page to specify the logon accounts for SQL Server services.
STEP 16: You can choose a default collation for your SQL Server instance.
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.
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.
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.
STEP 20: On the Filestream tab, you can decide if you want to have the Filestream feature enabled. To continue, click the Next button.
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.
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.
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.
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.
STEP 25: Installation would take 10-15 minutes, depending on the server configuration.
STEP 26: Finally, when installation is Done, you may be prompted that additional computer restart is required. Click the OK button to confirm.
STEP 27: Post completion, you will be able to view the status of every status.