Re: iFilters

Oooo, good find. Hopefully Mike Walsh saw this and will add it to the FAQ.

tk
"Alex E" <alex.elena@xxxxxxxxx> wrote in message
news:1153406957.673885.85270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Just an update to say I've finally solved the problem!

According to a MS KB article on Full Text Search in SQL 2005:
"Microsoft Full-Text Engine for SQL Server (MSFTESQL) service does not
load components that are not signed by Microsoft, by default.

A third party filter, such as a PDF filter, that is currently installed
on the server is not loaded by the MSFTESQL service by default after
upgrade."

This means in order to use filters you must force MSFTESQL to load
these components using this command:
exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go

After restarting the service (or the whole server) you will then be
able to index and search PDFs (or I assume any 3rd party installed
ifilters)

Thanks for your help Todd and Englebert, much appreciated!

Regards,
Alex



.

Relevant Pages

  • Re: iFilters
    ... "Microsoft Full-Text Engine for SQL Server (MSFTESQL) service does not ... A third party filter, such as a PDF filter, that is currently installed ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: iFilters
    ... "Microsoft Full-Text Engine for SQL Server (MSFTESQL) service does not ... A third party filter, such as a PDF filter, that is currently installed ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: iFilters
    ... "Microsoft Full-Text Engine for SQL Server (MSFTESQL) service does not ... A third party filter, such as a PDF filter, that is currently installed ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: March 29, 2006 total eclipse - IT admins WORST NIGHTMARE
    ... and NewsProxy is the answer for that. ... > Comcast news server. ... simply filters out what I dont want on the network. ... NewsProxy - Network level killfile and content filter for Usenet. ...
    (comp.security.firewalls)
  • Re: Getting rid of SMTP Q emails
    ... DWord for contentfilterstate to 1. ... That's too fun about restarting the SMTP service. ... I am going to whip this server in shape and get the SPAMMING under control. ... After you added connection filter provider you need to ...
    (microsoft.public.windows.server.sbs)
Loading