Microsoft SQL Server 2012 Express Edition SQL Server Express 2012 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 onto your PC. This is known as a local instance of SQL Express (as opposed to a shared/networked instance of Microsoft SQL Server). The databases that you create in Sentinel Visualizer will reside in this local instance.


System Requirements

Supported Operating System

Windows 7, Windows 8, Windows Server 2008 R8, Windows Server 2008 Service Pack 2

  • Processor
    • 32-Bit Systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended).
    • 64-Bit Systems: 1.4 GHz or faster processor.
  • RAM
    • Minimum 512 MB (2 GB or more is recommended).
  • Hard Disk Space
    • 2.2 GB of Disk Space

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


Installing SQL Server Express 2012 with Document Searching

  1. Download and execute the Sentinel Visualizer SQL Express Advanced setup using the link below.
    http://files.fmsasg.com/sv-ver9.0.htm

  2. Accept the 'Choose Directory For Extracted Files' by clicking [OK].

  3. The files will be extracted, and the setup will be launched.

  4. In the 'License Terms' window, check the box next to "I accept the license terms." and click [Next]. License Terms

  5. Wait for the Setup Files to install. Install Setup Files

  6. In the 'Feature Selection' window, check 'Full-Text and Semanitic Extractions for Search'. Click [Next]. Feature Selection

  7. In the 'Instance Configuration' window, verify the instance name is SENT4EXPRESS and click [Next].
    DO NOT change the instance's name. Instance Configuration

  8. In the 'Server Configuration' window, DO NOT change any of the Startup Types. Click [Next]. Server Configuration

  9. In the 'Database Engine Configuration' window, DO NOT change the password. Click [Next]. Database Engine Configuration

  10. In the 'Error Reporting' window, select if you would like to send errors to Microsoft. Click [Next]. Error Reporting

  11. Wait for the installation to complete. Installation Progress

  12. When the installation has been successfully completed, click the [Close] button. Installation Complete

  13. 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 will not immediately appear. Installing SSMS could take up to 20 or 30 minutes.

  14. 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 will not immediately appear. This is a relatively fast installation.

  15. Download and install the PDF iFilter 64.
    https://supportdownloads.adobe.com/detail.jsp?ftpID=5542

    Follow the prompts, click "Accept/Next/Yes" as necessary. Do Not make any changes. Please be patient as, sometimes, the screen prompts will not immediately appear. This is a relatively fast installation.

  16. Open SQL Server Management Studio (which was installed back in Step 14).
    Login information:
    • Login: sa
    • Password: S3ntinElL0gin:7@FMS
    SQL Server Management Studio
    The Server name will be the name of your server, follow by a back-slash (\), followed by SENT4EXPRESS. Examples of some Server names:
    • CORPORATEVM\SENT4EXPRESS
    • YOURNAMEOFFICE\SENT4EXPRESS
    • .\SENT4EXPRESS
    • NHQ26AA00273880\SENT4EXPRESS
    • WIN10-ACERPC\SENT4EXPRESS

  17. Select [New Query] from the toolbar.SQL Server Management Studio New Query

  18. Copy the Query below, by clicking the [Copy Text] button.

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

  19. Select the database to run the query against, paste the Query into the query window. Click the [Execute] button. SQL Server Management Studio Execute Query

  20. If the query was performed properly, this message will appear:
    "Commands completed successfully."

    If that message does not appear, confirm that "master" appears in the upper-left part of the screen and re-copy/re-run the query.
    SQL Server Management Studio

  21. Copy the next Query below, by clicking the [Copy Text] button.

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

  22. Paste the Query into the query window. Click the [Execute] button.

    At the very bottom of the screen, the following message should appear:
    "Query executed successfully." SQL Server Management Studio Execute Query

Microsoft Certified Partner

Microsoft Partner Netework

Partners Welcome

Do you provide services to government and commercial customers seeking analytic solutions?
Contact us

In-Q-Tel Portfolio Company

InQTel Portfolio Company
Learn more

Discover

Sentinel Visualizer Comparison to IBM's i2 Analyst's Notebook