Trusted by +1 Million customers | LIVE-DELIVERY

How to Install SQL Server 2019 Standard

01/11/2022
Isola Is
  • Introduction :

    The following steps will walk you through the setup and configuration of SQL Server 2019 Standard Edition. At the completion of this article you will have:

    • Installed a basic stand-alone instance of SQL Server 2019 Standard with the minimum features necessary for SQL Server.
    • Installed SQL Server Management Studio for managing the local database.

    1. Requirement :

    2. Steps to follow

      • Installing SQL Server 2019

        1. Launch the SQL Server installer from the download file.

          SQL Server 2019

        2. Click System Configuration Checker. This will enable you to launch and run a tool that checks for conditions on your server that could prevent SQL Server from installing.

        3. When the tool is launched, click the Show details button. A successful scan should look like the one shown below. If you encounter any issues, look at the detailed report, resolve the reported issues, and rerun the scan.

          SQL Server 2019

        4. Click OK when done to return to the “SQL Server Installation Center” window.

        5. In the “SQL Server Installation Center” window, click Installation then New SQL Server stand-alone installation or add features to an existing installation.

          SQL Server 2019

        6. Enter your product key and click Next.

          SQL Server 2019

        7. Check I accept the license terms, then checkbox and click Next.

          SQL Server 2019

        8. Wait for the Rule Check to run.

        9. Check the “Microsoft Update” box at the “Microsoft Update” step. Click Next after using Microsoft Update to check for updates (recommended) unless your software update process does not use Microsoft's automatic updates.

          SQL Server 2019

        10. Leave all defaults in the "Product Updates" step and click Next.

        11. Allow for the completion of the “Install Setup Files” step. Verify that all operations are successful. Click Next once the installation is complete.

          SQL Server 2019

        12. The only feature in “Feature Selection” necessary for Secret Server is “Database Engine Services.”

        13. Unless you are using Geo-Replication, you can leave everything else unchecked. Leave the directory locations unchanged and click Next.

          SQL Server 2019

        14. Leave "Default instance" selected in the "Instance Configuration" step.

        15. Choose a name (Instance ID) for your SQL Instance, then click Next.

          SQL Server 2019

        16. Leave the defaults in the “Server Configuration” step and click Next

          SQL Server 2019

        17. In the Database Engine Configuration window, you have the choice to select either Windows authentication mode or Mixed Mode. Select the option that will work best for your environment, see descriptions below:

          • Mixed Mode (for easier configuration):

            Mixed Mode is required if you intend on using a SQL Server account to authenticate Secret Server to your SQL Server instance. We recommend using Mixed Mode if you are setting up a test or demo environment. Selecting this option will also require you to set a password for the SQL Server system administrator (sa) account. See Adding a SQL Server User (section below) for instructions on adding more users.

          • Windows Mode (recommended for best security):

            This will prevent SQL Server account authentication. We recommend using Windows Mode for production environments. Whatever user or group assigned will have administrative access to your SQL instance. According to Best Security Practices, limit this number to as few users as possible.

          NB :By choosing Windows Mode you will also need to set up a service account to run your Thycotic product IIS Application Pool(s) later in the installation process.

          SQL Server 2019

        18. NB : Select an Administrator account to manage your SQL Server Database.

          You can leave the options in the remaining tabs at their default values or change the file locations in the “Data Directories” and “TempDB” tabs if you wish to store the database and log data in a different drive or directory, then click Next.

          Wait for the setup wizard to progress to the “Ready to Install” step and click Install.

          SQL Server 2019

          Wait for the installation to finish, this could take some time, then close the window.

      • Installing SQL Server Management Studio

        1. Back in the “SQL Server Installation Center” window, click Installation then Install SQL Server Management Tools

          SQL Server 2019

        2. Wait for the web page to load then click the Download SQL Server Management Studio.

        3. When the download is finished, click Run (if using Internet Explorer to download the file; if using a different browser, follow the conventions for that browser to run the file or open the download folder and run the file).

        4. Click Install when the SQL Server Management Studio installer starts.

          SQL Server 2019

        5. Wait for the installer to finish.This may take several minutes. When the installation is completed, click Restart if prompted. Otherwise, click Close and then close “SQL Server Installation Center.”

          SQL Server 2019

    3. Read also