Install Semantic Search - SQL-FineBuild/Common GitHub Wiki

Previous Install StreamInsight Manual Install Install Data Quality Services Next

FineBuild can install and configure Semantic Search as part of the SQL Server install process.

Semantic Search is written by Microsoft. It was chosen to be included in FineBuild because it configures a key part of SQL 2012 and above, used to discover statistically relevant insight through prominent words and similar content in documents stored in Full-Text indexes.

Item Link
Semantic Search home page https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/gg492075(v=sql.110)
Semantic Search download Semantic Search is included in the install media for SQL 2012 and above
Semantic Search video https://channel9.msdn.com/Shows/DataBound/DataBound-Episode-2-Semantic-Search

FineBuild Semantic Search Install

Automated silent installation of Semantic Search is performed by Process Id 4SL and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupSemantics: Yes Yes N/A
SQL2017 /SetupSemantics: Yes Yes N/A
SQL2016 /SetupSemantics: Yes Yes N/A
SQL2014 /SetupSemantics: Yes Yes N/A
SQL2012 /SetupSemantics: Yes Yes N/A
SQL2008R2 /SetupSemantics: N/A N/A N/A
SQL2008 /SetupSemantics: N/A N/A N/A
SQL2005 /SetupSemantics: N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter /InstSemantics: can also be used.

The FineBuild install for Semantic Search includes the following:

Top

Manual Semantic Search Install

The following steps show what you would have to do to install Semantic Search manually. FineBuild does all of this work for you automatically.

Semantic Search Template Database Install

This process will create a template Semantics Search database that can be copied and attached to each SQL 2012 or above instance on the server.

  1. Navigate to the _\x64\Setup_ folder in the SQL 2012 install media

    Double-click on SemanticLanguageDatabase.msi

Create Active Semantic Search Database

This process copies the template Semantics Search database to the SQL instance and attaches it ready for use.

  1. Navigate to the /VolData:\SQL Files\MSSQL.MSSQLSERVER.Data folder

    If a named instance is being installed than use that name in place of MSSQLSERVER

  2. Create a sub-folder called SemanticsDB

  3. Navigate to the _C:\Program Files\Microsoft Semantic Language Database_ folder in the SQL install media

    Double-click on SemanticLanguageDatabase.msi

  4. Copy the following files:

    Source Destination
    SemanticsDB.mdf DrvData:_DirSQL_\MSSQL.MSSQLSERVER.Data\SemanticsDB\
    Semanticsdb_log.ldf DrvLog:_DirSQL_\MSSQL.MSSQLSERVER.Log\

  5. Start SQL Server Management Studio (SSMS)

    Open a New Query window and run the following command, using the parameter values for your installation:

    CREATE DATABASE [SemanticsDB] ON
 (FILENAME=N'/VolData:\/DirSQL:\MSSQL.MSSQLSERVER.Data\SemanticsDB\semanticsDB.mdf') 
,(FILENAME=N'/VolLog:\/DirSQL:\MSSQL.MSSQLSERVER.Log\semanticsdb_log.ldf') 
FOR ATTACH

    For example:

    CREATE DATABASE [SemanticsDB] ON
 (FILENAME=N'J:\SQL Files\MSSQL.MSSQLSERVER.Data\SemanticsDB\semanticsDB.mdf') 
,(FILENAME=N'K:\SQL Files\MSSQL.MSSQLSERVER.Log\semanticsdb_log.ldf') 
FOR ATTACH

Register Semantic Search Database

This process registers the Semantics Search database to allow sematic data to be collected automatically.

  1. Run the following command: 
    EXEC sp_fulltext_semantic_register_language_statistics_db @dbname=N'SemanticsDB'

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install StreamInsight Top Install Data Quality Services Next