Microsoft KB Archive/945934

= How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008 =

Article ID: 945934

Article Last Modified on 12/18/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition

-



This article describes how to register Microsoft Filter Pack IFilters with Microsoft SQL Server 2005 and with SQL Server 2008. After you register the IFilters, you can enable additional file types for SQL Server to index.



MORE INFORMATION
To register Filter Pack IFilters, follow these steps:  Visit the following Microsoft Web site to download and install Microsoft Filter Pack:

http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC

Note The architecture of the Filter Pack must match the operating system architecture. For example, you must install the x86 version of the Filter Pack for x86-based operating systems. Start SQL Server Management Studio.

Note For more information about how to use SQL Server Management Studio, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms166996.aspx

 In SQL Server Management Studio, select the instance in which you want to enable IFilters, and then run the following command in that instance:

sp_fulltext_service 'load_os_resources', 1

 If you are running SQL Server 2008, go to Step 5. If you are running SQL Server 2005, stop and restart the msftesql service. To do this, follow these steps:  At a command prompt, type the following command and then press Enter:

net stop msftesql

Note To stop the msftesql service for a specific instance, run the following command:

net stop msftesql$

 At a command prompt, type the following command and then press Enter:

net start msftesql

Note To start the msftesql service for a specific instance, run the following command:

net start msftesql$

 </li> Restart the SQL Server service.</li></ol>

The following file types are supported by the Filter Pack.
 * .docx
 * .docm
 * .pptx
 * .pptm
 * .xlsx
 * .xlsm
 * .xlsb
 * .zip
 * .one
 * .vdx
 * .vsd
 * .vss
 * .vst
 * .vdx
 * .vsx
 * .vtx

Keywords: kbexpertiseadvanced kbhowto kbinfo KB945934

-

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

© Microsoft Corporation. All rights reserved.