Trusted by +1 Million customers | LIVE-DELIVERY

SQL 2019 Standard Installation

09/15/2021
Isola Is
    1. Requirements

    2. 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.

      • Created a database in SQL for your Thycotic product.

      • Created a new SQL Server user login for your SQl database.

    3. Steps to follow

      • Installing SQL Server 2019

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

          download file

        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.

          details button

        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.

          details button

        6. Enter your product key and click Next.

          details button

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

          details button

        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.

          details button

        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.

          details button

        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.

          details button

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

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

          details button

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

          details button

        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.

          Note: 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.

          details button

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

        18. 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.

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

          details button

        20. 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

      • Creating the SQL Server Database

        To install Secret Server or Privilege Manager, the Thycotic installer will create the SQL database for you if it does not exist and if the user account has permission to create a new database (this requires the dbcreator server role).

        If you are not using the Thycotic Installer, use the following steps to create a database manually through SQL Server Management Studio:

        1. Open SQL Server Management Studio by searching for it from the Windows Start screen.

        2. Connect to your SQL Server instance.

        3. Right click the Databases folder and select New Database…

          sql server 2019

        4. Enter a name for your database in the Database name field, and then click OK.

          sql server 2019

      • Adding a SQL Server User

        According to Security Best Practices, limit the number of users with access to your SQL database as much as possible.

        Use the following instructions to add a SQL Server account for Secret Server to use to access the SQL database:

        1. Open SQL Server Management Studio by searching for it from the Windows Start screen.

        2. Connect to your SQL Server Database.

        3. Expand the Security folder.

        4. Right-click the Logins folder and select New Login…

          sql server 2019

        5. Select a method of authentication:

          • SQL Server Authentication Use this option to create a new SQL Server account (this requires Mixed Mode to be enabled). To create the account, enter a new username and password and then deselect the Enforce password policy check box to prevent the account from expiring.

          • sql server 2019

          • Windows Authentication Use this option to add access to SQL Server for an existing Windows account. To add the account, enter the login name or click Search to find the account. It is recommended to use a domain account rather than a local Windows account.

        6. Click User Mapping in the left menu.

        7. Select the check box next to your Secret Server database.

        8. In the Database role membership window, select the db_owner check box.

          sql server 2019

        9. Click OK.