DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 945934 - Last Review: July 9, 2012 - Revision: 6.0

SUMMARY

This article describes how to register Microsoft Filter Pack IFilters with Microsoft SQL Server. After you register the IFilters, you can enable additional file types for SQL Server to index and perform full-text search. These additional file types include the file types that are supported by the 2007 Microsoft Office system and the 2010 Microsoft Office system.

MORE INFORMATION

To register Filter Pack IFilters, follow these steps:
  1. To download and install Microsoft Filter Packs, visit the following Microsoft websites:

    Microsoft Office 2007 Filter Packs
    http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC (http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC)

    Microsoft Office 2010 Filter Packs
    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5cd4dcd7-d3e6-4970-875e-aba93459fbee (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5cd4dcd7-d3e6-4970-875e-aba93459fbee)
    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.
  2. Start SQL Server Management Studio.
  3. 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
  4. 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:
    1. 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$ instance_name
    2. 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$ instance _name
  5. Restart the SQL Server service.

    Note This step is not necessary if you installed a Microsoft Office 2010 filter pack.
Supported file types

The following file types are supported by the Office 2007 Filter Pack:
Collapse this tableExpand this table
.docx.docm.pptx.pptm.xlsx
.xlsm.xlsb.zip.one.vdx
.vsd.vss.vst.vsx.vtx
The following file types are supported by the Office 2010 Filter Pack:
Collapse this tableExpand this table
.docx.docm.dotx.pptx.pptm.xlsx
.xlsm.zip.html.doc.xls.ppt
.dot.vss.vsd.vst.vdx.vsx
.vtx.vdw.one.odt.odp.ods
.msg.pub

REFERENCES

For more information about how to use SQL Server Management Studio, visit the following Microsoft Developer Network (MSDN) website:
http://msdn.microsoft.com/en-us/library/ms174173.aspx (http://msdn.microsoft.com/en-us/library/ms174173.aspx)

APPLIES TO
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • SQL Server 2012 Enterprise Core
Keywords: 
kbtshoot kbexpertiseadvanced kbhowto kbinfo KB945934
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support