Microsoft KB Archive/945539

= SQL Server 2005 cannot index some 2007 Office document formats =

Article ID: 945539

Article Last Modified on 12/5/2007

-

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

-



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:  Install Microsoft Office Word 2007.  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  On the computer, stop and restart the msftesql service, or stop and restart the msftesql$ service. To do this, use one of the following methods.  Stop and restart the msftesql service  At a command prompt, type net stop msftesql, and then press ENTER. At a command prompt, type net start msftesql and then press ENTER.</ol> </li> Stop and restart the msftesql$ service <ol style="list-style-type: lower-alpha;"> At a command prompt, type net stop msftesql$, and then press ENTER.</li> At a command prompt, type net start msftesql$ and then press ENTER.

Note The  placeholder represents the instance on which you want to enable the IFilter.</li></ol> </li></ul> </li></ol>

Note This resolution works only for x86-based versions of SQL Server 2005 because all versions of 2007 Office are x86-based.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB945539

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.