Trusted by +1 Million customers | LIVE-DELIVERY
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:
Launch the SQL Server installer from the download file.
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.
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.
Click OK when done to return to the “SQL Server Installation Center” window.
In the “SQL Server Installation Center” window, click Installation then New SQL Server stand-alone installation or add features to an existing installation.
Enter your product key and click Next.
Check I accept the license terms, then checkbox and click Next.
Wait for the Rule Check to run.
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.
Leave all defaults in the "Product Updates" step and click Next.
Allow for the completion of the “Install Setup Files” step. Verify that all operations are successful. Click Next once the installation is complete.
The only feature in “Feature Selection” necessary for Secret Server is “Database Engine Services.”
Unless you are using Geo-Replication, you can leave everything else unchecked. Leave the directory locations unchanged and click Next.
Leave "Default instance" selected in the "Instance Configuration" step.
Choose a name (Instance ID) for your SQL Instance, then click Next.
Leave the defaults in the “Server Configuration” step and click Next
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 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.
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.
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.
Wait for the installation to finish, this could take some time, then close the window.
Back in the “SQL Server Installation Center” window, click Installation then Install SQL Server Management Tools
Wait for the web page to load then click the Download SQL Server Management Studio.
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).
Click Install when the SQL Server Management Studio installer starts.
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.”