4.2 Microsoft SQL Server

4.2.1 Minimum Requirements

File Reporter supports the Standard and Enterprise versions of SQL Server. It does not support the Web or Express editions.

Microsoft SQL Server Software

  • SQL Server 2019 (Windows Server or Linux)

  • SQL Server 2017 (Windows Server or Linux)

  • SQL Server 2016 SP2

Server Host

  • Any Microsoft supported version of SQL Server running on a 64-bit multi-core processor machine

  • Minimum 16 GB RAM

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

For procedures on installing SQL Server, see https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server.

4.2.2 Prerequisites

Verify that you have installed the latest SQL Server updates prior to running the File Reporter Database Configuration utility.

4.2.3 Installing a New Instance of SQL Server

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

  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. When the Setup Support Rules operation is complete, click OK.

  5. When prompted, enter your product key, then click Next.

  6. Accept the license terms, then click Next.

  7. Include all Microsoft SQL Server product updates, then click Next.

  8. When the Setup Support Rules operation has completed, click Next.

  9. On the Feature Selection page, select Database Engine Services.

  10. Optionally specify custom paths or use the defaults for the installation paths, then click Next.

  11. In the Instance Configuration page, click the Named instance option and specify a descriptive name for the instance such as SRSDB and click Next.

  12. On the Server Configuration page, click the Collation tab.

  13. Click Customize.

  14. Click the Windows collation designator and sort order option.

  15. From the Collation designator drop-down menu, select an acceptable collation and settings for your locale.

    For example, in North America, an acceptable collation would be Latin1_General_100 with the Accent-sensitive check box selected.

    We recommend that you select a collation that aligns with the Windows locale of the server where the Engine is installed.

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

    IMPORTANT:File Reporter 4.1 does not support the UTF-8 char/varchar storage options at this time.

  16. Click OK.

  17. Click Next.

  18. On the Database Engine Configuration page, select the Mixed Mode (SQL Server authentication and Windows authentication) option, enter and confirm the SQL Server administrator password, then click Add Current User.

  19. Click Next.

  20. Click Install.

  21. When the installation has completed, click Close to close the wizard.

  22. Launch SQL Server Configuration Manager.

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

  24. Click Protocols for SRSDB (or the name of the database instance you chose earlier).

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

  26. Select the Protocol tab.

  27. Under the Enabled field, click the drop-down menu and select Yes.

  28. Select the IP Addresses tab.

  29. Under the IPAll heading, set the TCP Port field to an available port such as 1433.

  30. For the TCP Dynamic Ports field, set the value to 0 (zero).

  31. Click Apply.

  32. When the warning dialog box appears, click OK.

  33. Click OK to close the TCP/IP Properties window.

  34. Close the SQL Server Configuration Manager.

IMPORTANT:Firewall rules on the server hosting SQL Server may need configuration to allow for TCP port access to the TCP port specified during configuration.

4.2.4 Post Configuration Considerations

Review these points and make any needed adjustments to your SQL database settings before installing and configuring the File Reporter Engine and Web Application:

  • The SQL Server service must be listening via TCP/IP v4, because the Engine and Web Service requires that for access.

  • Some editions of SQL Server do not have TCP/IP enabled by default. If there are multiple instances, the instance that you just installed and configured might not be listening on the default port of 1433.

  • Firewall rules might need to be modified.