You can optionally add full text searching to an existing instance of SQL Express 2016. Full text searching allows the searching of embedded entity and relationship
documents.
System Requirements
Supported Operating System
Windows 10, Windows 8, Windows Server 2016, Windows Server 2019
Processor
Intel - Compatible processor with a minimum speed of 1 GHz or a faster processor.
RAM
Minimum 512MB
Hard Disk Space
4.2 GB of Disk Space
Limitation: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory and 10 GB storage.
Instructions
Use the following steps to add full text searching to your existing instance of SQL Express.
Exit Sentinel Visualiser, if the program is running.
If you have not downloaded SQL Server Express 2016, execute the download below. SQLEXPRADV_x64_ENU.exe
Select 'New SQL Server stand-alone installation or add features to an existing installation'.
Wait for the next screen to launch.
Select [License Terms], check the box next to 'I accept the license terms and Privacy Statement' and click [Next].
Select 'Add features to an exisiting instance of SQL Server 2016' and use SENT4EXPRESS as the instance. Click [Next].
Under 'Instance Features', select 'Full-Text and Semantic Extractions for Search'. Click [Next].
Accept the default settings for Server Configuration. Click [Next].
When the installation has been successfully completed, click the [Close] button.
The following message may appear when the installation is complete. If you receive this message restart your computer before using Sentinel Visualizer. Otherwise, you
can begin using Sentinel Visualizer.
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.
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.
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 will not immediately
appear. This is a relatively fast installation.
Open SQL Server Management Studio.
Select [New Query] from the toolbar.
Copy the Query below, by clicking the [Copy Text] button.