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, 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 SQL 2012 install media
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 installation of Semantic Search is performed by Process Id 4SL and is controlled by the parameters below:

Install Parameter Build SQL 2005 SQL 2008 SQL 2008 R2 SQL 2012
InstSemantics FULL N/A N/A N/A Yes
InstSemantics WORKSTATION N/A N/A N/A Yes
InstSemantics CLIENT N/A N/A N/A N/A


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 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 2012 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 2012 install media and double-click on SemanticLanguageDatabase.msi.

4) Copy the following files:

Source Destination
SemanticsDB.mdf DrvData:\SQL Files\MSSQL.MSSQLSERVER.Data\SemanticsDB\
Semanticsdb_log.ldf DrvLog:\SQL Files\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:\SQL Files\MSSQL.MSSQLSERVER.Data\SemanticsDB\semanticsDB.mdf') 
,(FILENAME=N'DrvLog:\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 © 2011 - 2013 Edward Vassie. License and Acknowledgements

Previous Install StreamInsight Top Install Data Quality Services Next

Last edited Mar 22, 2013 at 4:06 PM by EdVassie, version 7

Comments

No comments yet.