Help and Support

Article ID: 945539 - Last Review: December 5, 2007 - Revision: 1.2

SQL Server 2005 cannot index some 2007 Office document formats

Expand all | Collapse all

SYMPTOMS

Microsoft SQL Server 2005 cannot index the following 2007 Microsoft Office document formats:
  • docx
  • docm
  • pptx
  • pptm
  • xlsx
  • xlsm

CAUSE

This problem occurs because SQL Server 2005 does not contain the 2007 Office IFilter.

RESOLUTION

To resolve this problem, follow these steps:
  1. Install Microsoft Office Word 2007.
  2. In SQL Server Management Studio, run the following code on each instance on which you want to enable the IFilter.
    sp_fulltext_service 'load_os_resources', 1
  3. On the computer, stop and restart the msftesql service, or stop and restart the msftesql$instancename service. To do this, use one of the following methods.
    • Stop and restart the msftesql service
      1. At a command prompt, type net stop msftesql, and then press ENTER.
      2. At a command prompt, type net start msftesql and then press ENTER.
    • Stop and restart the msftesql$instancename service
      1. At a command prompt, type net stop msftesql$instancename, and then press ENTER.
      2. At a command prompt, type net start msftesql$instancename and then press ENTER.

        Note The instancename placeholder represents the instance on which you want to enable the IFilter.
Note This resolution works only for x86-based versions of SQL Server 2005 because all versions of 2007 Office are x86-based.

APPLIES TO
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB945539

Article Translations

 

Related Support Centers