Previous Install StreamInsight Manual Install Install Data Quality Services Next

Install Semantic Search

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.

Semantic Search home page http://msdn.microsoft.com/en-us/library/gg492075(v=sql.110).aspx
Semantic Search download Semantic Search is included in the install media for SQL 2012 and above
Semantic Search introduction http://msdn.microsoft.com/en-us/library/gg492075(v=sql.110).aspx
Semantic Search video http://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:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupSemantics FULL N/A N/A N/A Yes Yes
SetupSemantics WORKSTATION N/A N/A N/A Yes Yes
SetupSemantics CLIENT N/A N/A 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

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 and 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 DrvData:\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 and 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:

 CREATE DATABASE [SemanticsDB] ON
 (FILENAME=N'DrvData:\DirSQL\MSSQL.MSSQLSERVER.Data\SemanticsDB\semanticsDB.mdf') 
,(FILENAME=N'DrvLog:\DirSQL\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 © 2011 - 2014 Edward Vassie. License and Acknowledgements

Previous Install StreamInsight Top Install Data Quality Services Next

Last edited May 10, 2014 at 4:29 PM by EdVassie, version 12