SQL Server Express 2019 Installation Instructions

Sentinel Visualizer uses data stored in industry-standard, ODBC-compliant, Microsoft SQL Server databases. Microsoft SQL Server can be hosted on a dedicated server in your organization or in a cloud host like Microsoft Azure or Amazon Web Services (AWS).

You can also install a free copy of Microsoft SQL Server Express on your PC. This is a local instance of SQL Express (as opposed to a shared/networked instance of Microsoft SQL Server). The databases you create in Sentinel Visualizer can reside in this local instance.

System Requirements

• Windows Operating System
  • Windows 10, 11, and Windows Server 2016, 2019, 2022 or later
• Processor
  • Intel - Compatible processor with a speed of 1.4 GHz or faster.
• RAM
  • Minimum 512 MB
  • Recommended: 1 GB or more
• Hard Disk Space
  • 6 GB of Disk Space

Limitation: Microsoft SQL Server Express supports 1 physical processor, 1 GB RAM and 10 GB storage.

For more details visit SQL Server 2019 Hardware and Software Requirements.

Installing SQL Server Express 2019 with Document Searching

1. Download and execute the Sentinel Visualizer SQL Express Advanced setup using this link:
   https://files.fmsasg.com/SqlExpress/
2. Accept the 'Choose Directory For Extracted Files' by clicking [OK].
3. The files are extracted and the setup launches.
4. In the 'License Terms' window, check the box next to "I accept the license terms and Privacy Statement" and click [Next].
5. In the 'Microsoft Update' window, we recommend that you check the box, "Use Microsoft Update to check for updates (recommended).
6. Wait for the Setup Files to install.
   
7. When the 'Install Rules' window appears, click [Next]. (Note: Ignore the warning for the Windows Firewall.)
   
8. In the 'Feature Selection' window, DO NOT change any of the feature options. Click [Next].
   
9. In the 'Instance Configuration' window, verify the instance name is SENT4EXPRESS and click [Next].
   DO NOT change the instance's name.
   
10. In the 'Server Configuration' window, DO NOT change any of the Startup Types. Click [Next].
    
11. In the 'Database Engine Configuration' window, DO NOT change the password. Click [Next].
    
12. Wait for the installation to complete.
    
13. When the installation has been successfully completed, click the [Close] button.
    

Adding Document Content Searching

One of the powerful new features of Sentinel Visualizer is the ability to search the contents of documents like Word, Excel, and PDF files stored in the database. Follow these steps to add this functionality to your SQL Server installation.

Install These Programs

1. Download and install SQL Server Management Studio (SSMS).
   Follow the prompts, click "Accept/Next/Yes" as necessary. Do Not make any changes. Please be patient as, sometimes, the screen prompts do not appear immediately. Installing SSMS could take up to 20 or 30 minutes.
2. Download and install the Microsoft Office 2010 Filter Packs, named 'FilterPack64bit.exe'.
   https://www.microsoft.com/en-us/download/details.aspx?id=17062
   Follow the prompts, click "Accept/Next/Yes" as necessary. Do Not make any changes. Please be patient as, sometimes, the screen prompts do not appear immediately. This is a relatively fast installation.
3. Download and install the PDF iFilter 64.
   Follow the prompts, click "Accept/Next/Yes" as necessary. Do Not make any changes. Please be patient as, sometimes, the screen prompts do not appear immediately. This is a relatively fast installation.

Activate File Content Searching in SQL Server

1. Open SQL Server Management Studio which was installed in Step 1 and login:
   1. The Server Name is the name of your machine followed by a back-slash and SENT4EXPRESS. For instance, MyPC\SENT4EXPRESS
   2. Enter:
      • Login: sa
      • Password: S3ntinElL0gin:7@FMS
   3. Check Remember password to avoid entering this each time.
      
2. Select [New Query] from the toolbar.
   

3. Copy the Query below, by clicking Copy text

   EXEC sp_fulltext_service 'update_languages'; 
   EXEC sp_fulltext_service 'load_os_resources', 1;
   EXEC sp_fulltext_service 'restart_all_fdhosts';

4. Select the database to run the query against, paste the Query into the query window. Click the [Execute] button.
5. If successful, this message appears: "Commands completed successfully."
   If that message does not appear, confirm that "master" appears in the upper-left part of the screen and rerun the query.
   

6. Copy the next Query below, by clicking Copy text

   SELECT document_type
   FROM sys.fulltext_document_types
   WHERE document_type = '.docx' OR document_type = '.pdf'

7. Paste the Query into the query window. Click the [Execute] button.
   At the bottom of the screen, this message should appear: "Query executed successfully."