ArticlesArticles Most Popular ArticlesMost Popular Articles
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon 2019 Official Holidays & Support Schedule
DrillDown Icon IMPORTANT: End of Life of SHA1 on Windows Server 2003
DrillDown Icon IMPORTANT: Supported Operating Systems
DrillDown Icon PLEASE READ: Our Update Server IPs Have Changed
DrillDown Icon Support
DrillDown Icon modusGate for Microsoft Azure
DrillDown Icon modusCloud
DrillDown Icon Alleviating Spam – Best Practices
DrillDown Icon directQuarantine Technical Information
DrillDown Icon modusMail & modusGate Technical Information
DrillDown Icon Documentation & Release Information
DrillDown Icon Known Issues (non-release related)
DrillDown Icon Configuration Information
DrillDown Icon modusGate & modusMail
DrillDown Icon modusGate Only
DrillDown Icon modusMail Only
DrillDown Icon SQL Server Information
DrillDown Icon How-To: Enable Full Text Indexing for SQL Server Express
DrillDown Icon Known Issue: SQL Server Express Setup Problems on Windows 2000 Server
DrillDown Icon Info: Extended Database Format for ModusMail
DrillDown Icon How-To: Configure the SieveStore Database in SQL Server
DrillDown Icon How-To: Use SQL Server Instead of the Built-in MDB Database for Quarantine storage
DrillDown Icon How-to: Prevent Quarantine-Related Problems
DrillDown Icon How-To: Configure SQL TCP stack
DrillDown Icon How-To: Move SQL database from one server to another
DrillDown Icon MySQL Information
DrillDown Icon Security
DrillDown Icon Sieve
DrillDown Icon Spam and False-Positives
DrillDown Icon Statistics and Monitoring Section
DrillDown Icon Web Components
DrillDown Icon Troubleshooting
DrillDown Icon Hardware & OS System Requirements
DrillDown Icon Tools
DrillDown Icon Other Product Technical Information
DrillDown Icon Professional Services
DrillDown Icon Newsletters
  Email This ArticlePrint PreviewPrint Current Article/Category and All Sub-Articles/Categories
 
How-To: Enable Full Text Indexing for SQL Server Express
 

Product: All

Version & Build: All (required for 4.5 and above)

 

 

Background:

 

If you use Microsoft SQL Server (2000, 2005 or Express), full text indexing must be installed.  Full text indexing is required when upgrading to modus v4.5.

 

 

Procedure:

 

If SQL Server Express is already installed, proceed with the following instructions:

 

  • From the Control Panel, double-click on Add or Remove Programs
  • Select Microsoft SQL Server 2005 and click on Change
  • From the Component Selection menu, select SQLEXPRESS: Database Engine and click on Next
  • From the Feature Maintenance menu, select Database Engine
  • Click on Next until you arrive at the Change or Remove Instance menu (this may take a few minutes)
 
 
 
  • At the Feature Selection menu, expand Database Services, select Full-Text Search and click on Next until the installation completes

 

Note: 

 

·          If the SQL Server Express installation files are not available (i.e. they were deleted), you will be prompted for the installation files’ directory

·          Go to http://msdn.microsoft.com/vstudio/express/sql/download/ to download the SQL Express 2005 Advanced Services SP2 files

·          From a command prompt, type sqlexpr_adv.exe –x <enter>

·          When prompted, enter a directory into which the files will be extracted (e.g. c:\temp\sqlexpress)

·          Open Windows Explorer and  browse this directory

·          In the directory selection dialog, open the setup directory (e.g.: c:\temp\sqlexpress\setup) and double-click on  sqlrun_sql.msi

·          Upon completion of the installation, go to the SQL Server Configuration Manager where you should see a new SQL Server FullText Search (SQLEXPRESS) service

 


 
 
·          Restart all of the SQL Server services to enable full text indexing

 

 
Modified 1/8/2008
Keywords:
Article ID: 1621