more FREETEXT

Continuing problems with FREETEXT...
So... I went through the wizard to create FullText catalog, everything went
nice without problems (selected table and fields to search on)
The problem is that I still have Item Count 0 (properties of the catalog)
after rebuild and full population was done (I have about 1000 records in the
table)
Fields that were searched are "ntext" all containing some data
What to do? What could be problem?problem was that administrators were not un SQL users list and apparently
MSSearch service was not able to connect to server because of that
"borko" <borko@.borko.co.co> wrote in message
news:d81fbi$mmt$1@.ss405.t-com.hr...
> Continuing problems with FREETEXT...
> So... I went through the wizard to create FullText catalog, everything
> went nice without problems (selected table and fields to search on)
> The problem is that I still have Item Count 0 (properties of the catalog)
> after rebuild and full population was done (I have about 1000 records in
> the table)
> Fields that were searched are "ntext" all containing some data
> What to do? What could be problem?
>
>|||Borko,
For the benefit of others & to clarify for others who may also encounter
this problem with either FREETEXT or CONTAINS when using SQL Server 2000
Full-text Search (FTS), if you remove or alter the BUILTIN\Administrators
login, then the "Microsoft Search" (mssearch.exe) service will not be able
to connect to SQL Server. Thus the MSSearch service will not be able to
successfully execute a Full or Incremental Population (0 item count is a
symptom of this problem). There are several kb articles on this topic and a
pure TSQL workaround if the BUILTIN\Administrators login must not exist for
security reasons, you can use the following T-SQL code as a workaround:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"borko" <borko@.borko.co.co> wrote in message
news:d8m5vo$63m$1@.ss405.t-com.hr...
> problem was that administrators were not un SQL users list and apparently
> MSSearch service was not able to connect to server because of that
>
> "borko" <borko@.borko.co.co> wrote in message
> news:d81fbi$mmt$1@.ss405.t-com.hr...
catalog)[vbcol=seagreen]
>