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)





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.





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




·          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 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
Article ID: 1621