I want to enable full text search in sql server the feature already checked in the installation but in sql when i make this query
select serverproperty('IsFullTextInstalled')
The value 0 should be 1 ? How i can fix this issue?
from SQL server configuration manager it's Running ,
checked
Best Answer
You said that you have already installed the feature, but when you look at the sql server configuration manager do you see it there?
according to the documentation:
IsFulltextInstalled The full-text component is installed with the current instance of SQL Server.
0 = Full-text is not installed.
1 = Full-text is installed.
NULL = Invalid input, or error.
Here you can find a detailed way to install Full Text on SQL Server 2012:
Directions:
On the Installation Type screen, select the appropriate SQL Server instance.
Advance through the rest of the wizard.
Source (with screenshots): http://www.techrepublic.com/blog/networking/adding-sql-full-text-search-to-an-existing-sql-server/5546
This link is also a GREAT article, but a bit more comprehensive:
Step-by-Step: Enabling Semantic Search on SQL Server 2012
1.Install the Full-Text and Semantic Extractions for Search feature
2.Install the Microsoft Office 2010 Filter Packs and Service Pack 1
3.Install, attach and register the semantic language database
4.Create a full-text catalog
5.Create a full-text index with the Statistical_Semantics option enabled
Please visit this link for more details on the above instructions. There are pictures and more detailed info you can find there.
If you have this error message:
when you run these procedures below:
Then:
Check up what you find in the files below:
File Path Summary.txt %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log
Summary__Date.txt %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss
Detail.txt %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss
Datastore %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss\Datastore
MSI Log Files %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss\.log
ConfigurationFile.ini %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss
SystemConfigurationCheck_Report.htm %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss
For unattended installations %temp%\sqlsetup*.log
and also check sql server error log
Based on the information you get from the logs, you might need to deal with it accordingly, hopefully avoiding having to reinstall anything.
If you see this error message:
Check if you have enough permissions to run these procedures.
In regards to permissions the minimum requirement is: