Install Semantic Search

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:

• Semantic Search Template Database Install
• Create Active Semantic Search Database
• Register Semantic Search Database

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