Extended support for SQL Server 2005 ended on April 12, 2016. If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version.
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.
To register Filter Pack IFilters, follow these steps:
- To download and install Microsoft Filter Packs, visit the following Microsoft websites:
Microsoft Office 2007 Filter Packs
Microsoft Office 2010 Filter Packs
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.
- 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 or later, 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 msftesqlNote To stop the msftesql service for a specific instance, run the following command:net stop msftesql$ instance_name
- At a command prompt, type the following command and then press Enter:net start msftesqlNote To start the msftesql service for a specific instance, run the following command:net start msftesql$ instance _name
- At a command prompt, type the following command and then press Enter:
- Restart the SQL Server service, or do the following to load the new iFilters:
sp_fulltext_service 'Update_languages' go sp_fulltext_service 'Restart_all_fdhosts' go
- To verify the iFilters are now available in SQL Server, run the following command:
Select * from sys.fulltext_document_types
The following file types are supported by the Office 2010 Filter Pack:
Article ID: 945934 - Last Review: Dec 14, 2016 - Revision: 1