How to Install and Activate SQL Server 2016 Standard

08/24/2022
Isola Is
SQL Server 2016 Standard

Introduction:

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

  • Setup a minimal stand-alone instance of SQL Server 2016 Standard with the very minimum functionalities required for SQL Server.
  • Put SQL Server Management Studio on your computer to control your local database.

  1. Requirement:

  2. Steps to follow

    • Installation of SQL Server 2016

      1. Open the downloaded file to start the SQL Server setup.

        SQL Server 2016

      2. Select System Configuration Checker. By doing this, you'll be able to start and run a tool that analyzes your server for circumstances that might make it impossible for SQL Server to install.

      3. After starting the tool, select Show information. An effective scan should like the one below. If you run into any problems, check through the complete report, fix the problems, then restart the scan.

        SQL Server 2016

      4. When completed, click OK to go back to the "SQL Server Installation Center" window.

      5. Select New SQL Server stand-alone installation or add features to an existing installation from the Installation menu in the "SQL Server Installation Center" window.

        SQL Server 2016

      6. Click Next after inserting your product key.

        SQL Server 2016

      7. Click Next after selecting the "I accept the licensing conditions" option.

        SQL Server 2016

      8. The Rule Check must run first.

      9. When you get to the "Microsoft Update" phase, check the box. If your software update procedure does not employ Microsoft's automatic updates, click Next after using Microsoft Update to check for updates (recommended).

        SQL Server 2016

      10. Click Next after leaving the "Product Updates" phase at its default settings.

      11. Allow for the "Install Setup Files" process to be finished. Make sure everything is functioning properly. When the installation is finished, click Next.

        SQL Server 2016

      12. Only "Database Engine Services" is required for Secret Server out of the features listed under "Feature Selection."

      13. You may keep all other boxes unchecked unless you're utilizing Geo-Replication. Click Next after leaving the directory locations unchanged.

        SQL Server 2016

      14. In the stage under "Instance Configuration," keep "Default instance" selected.

      15. Click Next after selecting a name (Instance ID) for your SQL Instance.

        SQL Server 2016

      16. Click Next after leaving the "Server Configuration" step's default parameters unchanged

        SQL Server 2016

      17. You may choose between Windows authentication mode and Mixed Mode in the Database Engine Configuration box. Choose the one that will fit your setting the best; descriptions are underneath.

        • If you want to use a SQL Server account to authenticate Secret Server to your SQL Server instance, you must use Mixed Mode (for easier setting). If you are putting up a test or demo setup, we advise utilizing mixed mode. You will also need to create a password for the SQL Server system administrator (sa) account if you choose this option. For information on how to add more users, go to the section below titled Adding a SQL Server User.

        • Windows Mode: This will block SQL Server account authentication (recommended for optimal security). Windows Mode is suggested for use in production settings. Your SQL instance's administrative access will be granted to whichever user or group is designated. Best Security Practices recommend keeping this number of users as low as feasible.

        Please Note:To operate your Thycotic product's IIS Application Pool(s), you will also need to create a service account if you select Windows Mode later in the installation procedure.

        SQL Server 2016

      18. Note: To manage your SQL Server database, use an Administrator account

        If you want to store the database and log data on a different disk or directory, you may change the file locations in the "Data Directories" and "TempDB" tabs. Then click Next. You can keep the other tabs' choices at their default settings.

        Click Install once the setup procedure reaches the "Ready to Install" phase.

        SQL Server 2016

        Close the window after waiting for the installation to be finished, which might take some time.

    • SQL Server Management Studio installation

      1. When seeing the "SQL Server Installation Center" windows, go back.

        SQL Server 2016

      2. When the website has finished loading, click Download SQL Server Management Studio.

      3. Click Run when the download is done (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. When the installation for SQL Server Management Studio launches, select Install.

        SQL Server 2016

      5. Wait for the installation to complete. This might take some time. If requested to restart when installation is complete, choose Restart. If not, press Close to end the session with "SQL Server Installation Center."

        SQL Server 2016

    • Setting Up the SQL Server Database

      1. If the SQL database doesn't already exist and the user account has access to build a new database, the Thycotic installer will create it for you so that you may install Secret Server or Privilege Manager (this requires the dbcreator server role).

        Using SQL Server Management Studio, perform the following steps to manually build a database if you are not using the Thycotic Installer:

      2. From the Windows Start screen, look for SQL Server Management Studio and launch it.

      3. Link up to your SQL Server instance.

      4. Choose New Database simply right-clicking the Databases folder.

        SQL Server 2016

      5. In the Database name section, type a name for your database, and then click OK.

        SQL Server 2016

    • How to Add a SQL Server User

      1. Reduce the number of people who have access to your SQL database as much as you can, in accordance with security best practices.

        To install a SQL Server account that Secret Server may use to access the SQL database, complete these steps:

      2. From the Windows Start screen, look for SQL Server Management Studio and launch it.

      3. Access to your SQL Server database.

      4. Extend the folder Security.

      5. Right-click the Logins folder and choose New Login...

        SQL Server 2016

      6. Choose an authentication method:

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

          SQL Server 2016

        • Microsoft Authentication To provide an existing Windows account access to SQL Server, use this option. Enter the login name to add the account, or click Search to find the account. Using a domain account is advised over a local Windows account.

      7. Go to the left menu and choose User Mapping.

      8. Click the box next to your Secret Server database.

      9. Select the db owner check box in the Database role membership window.

        SQL Server 2016

      10. Select OK.