SQL Server 2005 Full Text Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joris De Groote - 23 Mar 2006 13:09 GMT

Hi,

I'm trying to use a SQL Server 2005 with WSS (Sharepoint Services). I try to
index the files in the WSS however this just doesn't work. I have set the
full-text in Sharepoint & the service in SQL Server 2k5 is installed and
running.
I have this working in SQL Server 2k, why isn't this working in SQL Server
2k5?

Thanks
Joris

Reply to this Message

Hilary Cotter - 24 Mar 2006 16:26 GMT

It does for me. What error message are you getting? What document types do
you have? You may have to enable the loading of third party ifilters, ie
sp_fulltext_service 'verify_signature', 1 sp_fulltext_service
'load_os_resources',0

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks
> Joris

Reply to this Message

Joris De Groote - 27 Mar 2006 09:23 GMT

Hi,

It's for PDF files. I have iFilter installed but it doesn't want to index
the files, but in SQL Server 2000 it does.

Where can I enable that it uses thied party ifilters?

Thanks
Joris De Groote

> It does for me. What error message are you getting? What document types do
> you have? You may have to enable the loading of third party ifilters, ie
[quoted text clipped - 14 lines]
>> Thanks
>> Joris

Reply to this Message

Hilary Cotter - 27 Mar 2006 15:31 GMT

Those instructions were for SQL 2005. Check the gatherer logs to see if they
are complaining about there files.

Signature

> Hi,
>
[quoted text clipped - 25 lines]
>>> Thanks
>>> Joris

Reply to this Message