Microsoft SQL Server

Supported Versions

File Reporter 25.3 supports the following versions of SQL Server:

• SQL Server 2022
• SQL Server 2019

System Requirements

• Any Microsoft supported platform for SQL Server on Windows Server or Linux.

  • https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022

  • https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019

  • https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-overview

• Minimum 16 GB RAM

  Depending on the size and frequency of your scans, you might need significantly more RAM

Supported Editions

The following editions of SQL Server are supported in production:

• SQL Server Enterprise
• SQL Server Standard

Install a New Instance of SQL Server

The following procedures are specific to Microsoft SQL Server 2022. Procedures will vary based on your version of SQL Server.

These instructions assume that you are installing a single instance of SQL Server on a Windows Server host with no Azure integration.

1. From the Microsoft SQL Server ISO, double-click setup.exe.

2. On the SQL Server Installation Center page, click Installation.

3. Select New SQL Server stand-alone installation or add features to an existing installation.
   

4. Complete the following forms in the SQL Server Setup wizard:

   1. Edition - select the SQL Server edition, enter the product key, select the license option, then click Next.

   2. License Terms - accept the license terms and click Next.

   3. Global Rules - view the results then click Next.

   4. Microsoft Update - click Use Microsoft Update to check for updates then click Next.

   5. Install Rules - review the results then click Next.

   6. Azure Extension for SQL Server - uncheck Azure Extension for SQL Server then click Next.

   7. Feature Selection - check Database Engine Services.

      

      Review the installation paths then click Next.

      NOTE: For larger installations consider installing the SQL Server instance on a separate volume by changing the Instance Root Directory path parameter.

   8. Feature Rules - review the results then click Next.

   9. Instance Configuration - Select the appropriate instance type, modify the Instance ID if desired, then click Next.

   10. Server Configuration - select the Collation tab then click Customize.

       

       • Select Windows collation designator and sort order then select your desired collation.

         If possible select a collation that aligns with the Windows Server hosting the 25.3 Engine.
         

         If you are unsure which collation to use, select Latin1_General_100 which is a safe option for File Reporter.

         NOTE: Select one of the *_100 or later collations as these offer the best compatibility for advanced options such as Supplementary characters.

         For more information on collation and locales, refer to this Microsoft document:
         
         https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support.

         IMPORTANT: 25.3 requires the use of a Windows collation. Legacy SQL collations are not supported.

       • [Optional] Select Accent-sensitive and Supplementary characters.

       • [Optional] Select options for Kana-sensitive, Width-sensitive, and Variation selector-sensitive if you understand their impact with specific Asian character sets.

       • Deselect all other options.

       • Select Windows Code Page (1252) for the Char/Varchar Storage Options.

         IMPORTANT: File Reporter does not support the use of UTF-8 as a character storage option at this time.

       Click OK to close the Collation customization dialog then click Next.

       Database Engine Configuration - perform the following operations in this panel:

       • Select Mixed Mode (SQL Server authentication and Windows authentication).

       • Enter a password for the sa account in the Enter password and Confirm password fields.

       • Click Add Current User to add your current account to the SQL Server administrators list.

       

       Review your selections then Click Next.

   11. Feature Configuration Roles - review any messages then click Next.

   12. Ready to Install - perform a final review of all installation options then click Install.

   13. Complete - once the installation is complete click Close to exit the setup wizard.

5. From the Windows Start Menu launch SQL Server Configuration Manager.

   1. In the left pane, expand SQL Server Network Configuration.

   2. Click Protocols for MSSQLSERVER (or the name of the database instance you chose earlier).
      

   3. Right-click TCP/IP and select Properties.

   4. Click the Protocol tab.

   5. Set the Enabled field to Yes.

   6. Set the Listen All field to Yes.

   7. Click the IP Addresses tab.

   8. Under the IPAll heading at the bottom, set the TCP Port field to 1433
      

   9. Click OK.

   10. Close the SQL Server Configuration Manager.

6. Launch Windows Firewall with Advanced Security.

   1. From the left column, click Inbound Rules.

   2. From the Actions column, click New Rule.

   3. In the Rule Type page, select Port.
      

   4. Click Next.

   5. In the Protocol and Ports page, enter 1433 in the Specific local ports field, then click Next.

   6. In the Action page, accept the default setting by clicking Next.

   7. In the Profile page, accept the default settings by clicking Next.

   8. In the Name page, specify a name for the new inbound rule in the Name field.

      For example, SQL Server.

   9. Click Finish.