Install and Configure iFilter

iFilter is a tool that allows to search contents stored in SQL Server Database. You can install and configure the iFilter for each individual MIME type like PDF, TIFF, Office Documents etc. Below is the list that explains how one can install and configure the iFilters for different MIME Types:

 

PDF

 

For 64-bit Operating System (OS):

 

You can download the pdf iFilter from below given link:

 

http://www.adobe.com/support/downloads/detail.jsp?ftpID=5542

 

After downloading PDF iFilter, Unblock the file and then proceed with installing iFilter. On successful installation of iFilters, you should see multiple .dll files at below location:

 

C:\Program Files\Adobe\Adobe PDF iFilter 'Version' for 64-bit platforms\bin\

 

Now, follow the below steps to make necessary changes to the Environment Variables:

 

1. Go to Start menu>> Right click on My Computer>> Select Properties>> Click on Advanced System Settings>> Click on Environment Variables button under Advanced tab.

 

2. Now, locate 'Path' under System Variables section and click on Edit button.

 

3. Edit System Variable prompt will open. Under Variable Value field, you need to append the below path (separated by ;) to the existing Variable Value. Click OK to save the values.

 

C:\Program Files\Adobe\Adobe PDF iFilter 'Version' for 64-bit platforms\bin\

 

4. Now, locate 'PATHEXT' under System Variables section and click on Edit button.

 

5. Then, under Variable Value field, you need to add .DLL extension (separated by ;) to the existing Variable Value and click on OK button save the values.

For Example: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.DLL

 

After installing the iFilter, check whether Adobe iFilter is registered with the server or not. From the SQL Server in a new query window type and execute the following:

 

1. EXEC sp_fulltext_service 'load_os_resources', 1

2. EXEC sp_fulltext_service 'verify_signature', 0

 

On completion of above configuration steps, restart the SQL Server machine.​

 

You should see list of installed iFilters in the output window after executing below command against SQL Server.

 

SELECT * from sys.fulltext_document_types

 

For 32-bit Operating System (OS):

 

You can download the pdf iFilter from below given link:

 

http://www.adobe.com/support/downloads/thankyou.jsp?ftpID=2611&fileID=2457

 

After downloading PDF iFilter, Unblock the file and then proceed with installing iFilter. On successful installation of iFilters, you should see multiple .dll files at below location:

 

Now, follow the below steps to make necessary changes to the Environment Variables:

 

1. Go to Start menu>> Right click on My Computer>> Select Properties>> Click on Advanced System Settings>> Click on Environment Variables button under Advanced tab.

 

2. Now, locate 'Path' under System Variables section and click on Edit button.

 

3. Edit System Variable prompt will open. Under Variable Value field, you need to append the below path (separated by ;) to the existing Variable Value. Click OK to save the values.

 

C:\Program Files\Adobe\PDF IFilter 6.0\

 

4. Now, locate 'PATHEXT' under System Variables section and click on Edit button.

 

5. Then, under Variable Value field, you need to add .DLL extension (separated by ;) to the existing Variable Value and click on OK button save the values.

For Example: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.DLL​

 

After installing the iFilter, check whether Adobe iFilter is registered with the server or not. From the SQL Server in a new query window type and execute the following:

 

1. EXEC sp_fulltext_service 'load_os_resources', 1

2. EXEC sp_fulltext_service 'verify_signature', 0

 

On completion of above configuration steps, restart the SQL Server machine.​

 

You should see list of installed iFilters in the output window after executing below command against SQL Server.

 

SELECT * from sys.fulltext_document_types

 

TIFF

 

For tiff files stored in the database, the native content search can only be enabled for Windows 7 or higher Operating Systems. You can browse to below given link to get details on installing the Windows TIFF iFilter:

 

http://technet.microsoft.com/en-us/library/dd755985(v=WS.10).aspx

 

After installing the windows TIFF iFilter, you need to enable it using by following the steps mentioned in below article:

 

http://technet.microsoft.com/en-us/library/dd744689(v=ws.10).aspx

 

Note:

Content indexing of TIFF files is not supported when the operating system on the SQL Server machine hosting the PaperSave database is 32-bit.​ In this case, you may see a warning message while running PaperSave Pre-requisite Checker setup. You can ignore the warning by clicking on Next button and proceed further.

 

iFilter Pack for native content search for MS-Office Documents:

 

To enable Full Text Search for Microsoft Office documents, you need to install the different iFilter packs available specific to the version of the MS-Office installed on the SQL server. Below article helps you to install the iFilter packs for MS-Office:

 

http://support.microsoft.com/kb/945934

 

Note:

SELECT * from sys.fulltext_document_types - this statement can be used to check which MIME type extensions are enabled for performing the full text content search from SQL server.

 

Note:

Please take a note that you may see below error message, if you have started installing iFilters in an ongoing PaperSave installation like, PaperSave Rollup, PaperSave ISO or Pre-requisite checker and then clicked on Rescan button to verify the requirement again. Still the pre-requisite may get fail displaying the below error. Under such circumstances you need to exit the setup and re-run the respective PaperSave Setup again​.

 

"Test Failed for verifying that the iFilters are installed and that the Content Indexing with Full Text Search is working. Cannot open database "PaperSaveContentSearchTest" requested by the login. The login failed. Login failed for user 'XYZ'."