Microsoft SQL Server 2012 Express Edition Add Full Text Search to an Existing Instance of SQL Server Express 2012

You can optionally add full text searching to an existing instance of SQL Express 2012. Full text searching allows the searching of embedded entity and relationship documents.

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.


Instructions

Use the following steps to add full text searching to your existing instance of SQL Express.

  1. Exit Sentinel Visualiser, if the program is running.

  2. If you have not downloaded SQL Server Express 2012, execute the download below.
    SQLEXPRADV_x64_ENU.exe

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

  4. Wait for the next screen to launch. Microsoft SQL Server 2012 Setup

  5. Select [License Terms], check the box next to 'I accept the license terms.' and click [Next]. Microsoft SQL Server 2012 License Terms

  6. Select 'Add features to an exisiting instance of SQL Server 2012' and use SENT4EXPRESS as the instance. Click [Next]. Microsoft SQL Server 2012 Instance

  7. In the 'Feature Selection' window, under 'Instance Features', select 'Full-Text and Semantic Extractions for Search'. Click [Next]. Full-Text and Semantic Extractions for Search

  8. Accept the default settings for Server Configuration. Click [Next]. Server Configuration

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

  10. When the installation has been successfully completed, click the [Close] button. Install Complete

  11. 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. Microsoft SQL Server 2012 Restart

  12. 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.

  13. 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.

  14. 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.

  15. Open SQL Server Management Studio. SQL Server Management Studio

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

  17. 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';
    

  18. 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

  19. Verify the installation was configured properly.

  20. 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'
    

  21. Paste the Query into the query window. Click the [Execute] button. SQL Server Management Studio Execute Query

Microsoft Certified Partner

Microsoft Partner Network

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