FT Searching in SQL Server Database  
Author Message
Trygve





PostPosted: Thu Dec 04 01:22:03 CST 2003 Top

SQL Server >> FT Searching in SQL Server Database

We've got a small Windows SharePoint Services site that stores content
in a remote SQL Server Database. Over the last couple of weeks I've
been trying to get the Search Service working to no avail - no results
are being returned when a search is being performed.

I've posted this to the Windows Sharepoint Group, but I suspect the
problem may be with the SQL Server installation. Here's a summary of
the setup/things checked... any pointers would be appreciated!

1. I'm running SQL Server 2000 with SP3

2. The Full Text component of SQL Server is installed

3. The Microsoft Search Service is running and logged in using local
system admin account

4. There are no errors reported in the Event Log


A clean install of WSS was performed and the FT Search and Indexing
option for the site under SharePoint is all configured correctly.

When I look at the WSS Installation Guide it talks about an empty
index being created called ix_<databasename> when WSS is installed. I
have very little experience of SQL Server, but I did check this using
Enterprise Manager and nothing exists under the Full Text Catalogs
node. Is it possible to recreat this manually?

Thanks.

SQL Server264  
 
 
John





PostPosted: Thu Dec 04 01:22:03 CST 2003 Top

SQL Server >> FT Searching in SQL Server Database Steve,
Windows SharePoint Services or WSS as it's sometimes called, can use SQL
Server's Full-Text Search (FTS) components. However, you need to do a couple
of things when you migrate or upgrade from WMSDE (a special Windows 2003
version of MSDE) to SQL Server. Specifically, for your named instance
"SHAREPOINT", when you upgraded to SQL Server, under Server Components, did
you elect the Full-text Search check box?

Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John




> We've got a small Windows SharePoint Services site that stores content
> in a remote SQL Server Database. Over the last couple of weeks I've
> been trying to get the Search Service working to no avail - no results
> are being returned when a search is being performed.
>
> I've posted this to the Windows Sharepoint Group, but I suspect the
> problem may be with the SQL Server installation. Here's a summary of
> the setup/things checked... any pointers would be appreciated!
>
> 1. I'm running SQL Server 2000 with SP3
>
> 2. The Full Text component of SQL Server is installed
>
> 3. The Microsoft Search Service is running and logged in using local
> system admin account
>
> 4. There are no errors reported in the Event Log
>
>
> A clean install of WSS was performed and the FT Search and Indexing
> option for the site under SharePoint is all configured correctly.
>
> When I look at the WSS Installation Guide it talks about an empty
> index being created called ix_<databasename> when WSS is installed. I
> have very little experience of SQL Server, but I did check this using
> Enterprise Manager and nothing exists under the Full Text Catalogs
> node. Is it possible to recreat this manually?
>
> Thanks.