SQL 2019 Standard Installation

Requirements

• SQL 2019 Download file
• Operating system: Windows 11, Windows 10 , Windows Server 2016 , Windows Server 2019

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.

Steps to follow

• Installing SQL Server 2019

  1. Launch the SQL Server installer from the 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.

     

  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.

     

  6. Enter your product key and click Next.

     

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

     

  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.

     

  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.

      

  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.

      

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

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

      

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

      

  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.

      

      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.

      

  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

     

  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.

     

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

     

• 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…

     

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

     

• 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…

     

  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.

     

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

     

  9. Click OK.