Fog Creek Software
Discussion Board




Full text search not working

I've just installed the full version of FogBugz on IIS 5.0 and SQL server 2000.

I migrated my trial database over per the instructions in the support area, and created the Full text catalog.  I then did a re-build to make sure it was fresh.

When I do searches, it does not pick up anything in the BugEvent, only the title.

The catalog was created on BugEvent, with the column 's' being indexed.

No errors are in the server log, and the job for updating the index can be run successfully from the management/SQL Server Agent/jobs section.

Any suggestions on where to look next?

Bob Gusek
Friday, October 03, 2003

What is the size of the catalog after you run the full population?

Michael H. Pryor
Friday, October 03, 2003

1 MB for 164 rows in BugEvent

Bob Gusek
Saturday, October 04, 2003

Looking on the catalog, something is definitely not working.  The catalog shows an item count of 0.

Bob Gusek
Saturday, October 04, 2003

Ok found the problem, the BUILTIN/Administrator account was not on the SQL Server (this is a new installation on a Server 2003 machine).

I've added it back and working on getting it to run.

Thanks

Bob Gusek
Saturday, October 04, 2003

Ok after a little putzing around with the security settings and the Microsoft Search Service account it's now working great.

Thanks

Bob Gusek
Saturday, October 04, 2003

*  Recent Topics

*  Fog Creek Home