Contents x
    Installing SQL Server
    • 14 Aug 2023
    • 2 Minutes to read
    • Contributors
    • Print
    • Dark
      Light
    Contents

    Installing SQL Server

    • Updated on 14 Aug 2023
    • 2 Minutes to read
    • Contributors
    • Print
    • Dark
      Light
    Article summary

    This article goes through a base installation of a SQL Express server. Other settings and options can be modified as needed, but these are the basics that are required to work with RapidIdentity MFA. Google search for the SQL installer of the version you want and be sure to download it from the official Microsoft website.

    Installing SQL

    1. Right-click the SQL installer and "Run as administrator". Click "Yes" when the UAC prompt appears.

    2. When the install wizard appears, select the "Custom" option.
      sql-install-1.png

    3. On the next page, confirm or change the install path and click "Next".
      sql-install-2.png

    4. The SQL Server Installation Center window will appear. Select "New SQL Server stand-alone installation...".
      sql-install-3.png

    5. Accept the license terms and click "Next".
      sql-install-4.png

    6. Wait for the Install Rules to check the respective rules.
      sql-install-5.png

    If you you have not opened the SQL ports per the MFA Server Requirements page, you will receive the warning symbol next to Windows Firewall. It is only a warning and can be ignored at this point in the process. However, you can also open the port in your firewall and re-run the check before moving on.

    1. On the Feature Selection page, uncheck "Machine Learning Services".
      sql-install-6.png

    2. In the Instance Configuration page, you can stick with the "Default instance" or "Named instance". Click "Next".
      sql-install-7.png

    3. Set the "SQL Server Browser" to "Automatic". Hit "Next".
      sql-install-8.png

    4. Select "Mixed Mode" and set the Server Administrator (sa) password. You can add more users users as neccessary in the Specify SQL Server administrators section.
      sql-install-9.png

    This option is important so that other users created later have access to the MFA database. If the server is in "Windows authentication mode", any SQL usernames and passwords will not have the access needed to the database, especially when setting up the connection strings between the database and MFA software.

    1. On the Feature Configuration Rules, click "Next" when ready to begin the installation.

    2. Wait for the install to complete. When it brings you to the Complete page, click "Close".

    Installing SQL Server Mgmt Studio

    1. Back in the SQL Server Installation Center, select "Install SQL Server Management Tools".
      sql-install-11.png

    2. Your default browser will open to Microsoft's download page for the latest SSMS installer. Scroll down to Download SSMS and click the "Free Download..." link.
      sql-install-12.png

    3. Once the installer has downloaded, open it and click through the wizard to install SSMS.

    Post Installation Configuration

    1. In the Start menu, search for the SQL 20XX Configuration Manager and click to open it.
      sql-post-install 1.png

    2. On the left-hand side of the manager, expand:
      SQL Server Network Configuration > Protocols for SQLEXPRESS
      sql-post-install 2.png

    The SQL server name may appear differently depending on your setup, but the wording will be the same: "Protocols for [server name]"


    1. On the right-hand side, for both Named Pipes and TCP/IP, right-click and click "Enable".
      sql-post-install 3.png

    2. A warning will appear telling you the SQL server service will need to be restarted. Click "OK".
      sql-post-install 4.png

    3. Once both protocols are enabled, go to SQL Server Services on the left-hand side.

    4. Select your "SQL server (server name)", right-click and select "Restart".
      sql-post-install 6.png

    Once the restart has complete, you have completed the SQL server installation and configuration.

    Was this article helpful?
    What's Next