Microsoft SQL Server 2005 cannot index the following 2007 Microsoft Office document formats:
This problem occurs because SQL Server 2005 does not contain the 2007 Office IFilter.
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$instancename 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.
- Stop and restart the msftesql$instancename service
- At a command prompt, type net stop msftesql$instancename, and then press ENTER.
- 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.