Cannot enable full text indexing

I also have the 'greyed-out' menu problem for full-text indexing and have
researched every post and article available.
The MSSEARCH service is running, and the SQL Server 2000 is upgraded through
SP3a. The Security tab for the server is set for "SQL Server and Windows"
authentication and the Startup Service Account is "System account". The EM
will not allow a change to "This account ... LocalSystem"--it changes back to
"System account" when the change is made.
I have also tried executing sp_fulltext_database in Query Analyzer and
receive this error:
"Full-Text Search is not installed, or a full-text component cannot be
loaded."
There are no icons for full-text indexing under Support Services in EM and I
am wondering if SQL Server itself needs to be re-installed. I have
re-installed SP3, but have not done a complete SQL Server re-install.
I am running this server under XP Professional on a local machine.
What is missing here?
seeker
can you run this script on your problem machine? Post the results back here.
save this script as a vbs file and run it from the command prompt
You many need to do a cscript.exe //H:CScript if you get a lot of dialog
boxes.
Set objSearchAdmin=CreateObject("MSSearch.Admin")
Set infoNT=CreateObject("WinNTSystemInfo")
wscript.echo"Host Name: "& objSearchAdmin.HostName
objSearchAdmin.HostName =InfoNT.ComputerName
Set objApplications=objSearchAdmin.Applications
wscript.echo "Number of Search Applications serviced by this Build Server: "
& objApplications.Count
for each application in objApplications
wscript.echo "Application Name: " & application.name
next
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"seeker" <seeker@.discussions.microsoft.com> wrote in message
news:75D2062B-0704-4847-9388-0D16866D9AF0@.microsoft.com...
> I also have the 'greyed-out' menu problem for full-text indexing and have
> researched every post and article available.
> The MSSEARCH service is running, and the SQL Server 2000 is upgraded
through
> SP3a. The Security tab for the server is set for "SQL Server and Windows"
> authentication and the Startup Service Account is "System account". The
EM
> will not allow a change to "This account ... LocalSystem"--it changes back
to
> "System account" when the change is made.
> I have also tried executing sp_fulltext_database in Query Analyzer and
> receive this error:
> "Full-Text Search is not installed, or a full-text component cannot be
> loaded."
> There are no icons for full-text indexing under Support Services in EM and
I
> am wondering if SQL Server itself needs to be re-installed. I have
> re-installed SP3, but have not done a complete SQL Server re-install.
> I am running this server under XP Professional on a local machine.
> What is missing here?
> --
> seeker
|||Thank you for your note, Hilary.
I resolved this problem with a re-install of SQL Server (Developer). When I
put in the CD, I discovered that it had been installed with Full Text
Indexing unchecked, which is the default.
I took it all the way through the SP3 update, and at the point the Full Text
Indexing selection was enabled.
"Hilary Cotter" wrote:

> can you run this script on your problem machine? Post the results back here.
> save this script as a vbs file and run it from the command prompt
> You many need to do a cscript.exe //H:CScript if you get a lot of dialog
> boxes.
> Set objSearchAdmin=CreateObject("MSSearch.Admin")
> Set infoNT=CreateObject("WinNTSystemInfo")
> wscript.echo"Host Name: "& objSearchAdmin.HostName
> objSearchAdmin.HostName =InfoNT.ComputerName
> Set objApplications=objSearchAdmin.Applications
> wscript.echo "Number of Search Applications serviced by this Build Server: "
> & objApplications.Count
> for each application in objApplications
> wscript.echo "Application Name: " & application.name
> next
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "seeker" <seeker@.discussions.microsoft.com> wrote in message
> news:75D2062B-0704-4847-9388-0D16866D9AF0@.microsoft.com...
> through
> EM
> to
> I
>
>
sql

Cannot Create Full-Text Catalog

I had a perfectly good FT catalog, but I was trying to repopulate it after
making changes to the noiseeng file. I restarted the Full-Text search
engine.
When I tried to run a full-text query against the table, I got this error
"no such interface supported". In the message there was a recommendation to
create a new catalog.
I decided to delete the existing catalog, but now cannot create a new one.
I get the following full message:
TITLE: Microsoft SQL Server Management Studio
Cannot execute changes.
Create failed for FullTextCatalog 'FTCDoctors'. (Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+FullTextCatalog&LinkId=20476[/url]
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Execution of a full-text operation failed. 'No such interface supported'
(Microsoft SQL Server, Error: 7689)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .3054&EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476[/url]
The links are dead links now. Figures.
Can anyone help me?
Thanks, Ross
Unable to find a cure, I uninstalled the Full-Text engine, rebooted,
reinstalled Full-Text, rebooted and was able to rebuild the catalog and
index. But I'd sure like to know what happened and what this error really
means.
Ross
"Ross Culver" <rculver@.warrenalloy.com> wrote in message
news:eOCFu7brHHA.4180@.TK2MSFTNGP04.phx.gbl...
>I had a perfectly good FT catalog, but I was trying to repopulate it after
> making changes to the noiseeng file. I restarted the Full-Text search
> engine.
> When I tried to run a full-text query against the table, I got this error
> "no such interface supported". In the message there was a recommendation
> to
> create a new catalog.
> I decided to delete the existing catalog, but now cannot create a new one.
> I get the following full message:
> TITLE: Microsoft SQL Server Management Studio
> Cannot execute changes.
> Create failed for FullTextCatalog 'FTCDoctors'. (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+FullTextCatalog&LinkId=20476[/url]
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Execution of a full-text operation failed. 'No such interface supported'
> (Microsoft SQL Server, Error: 7689)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .3054&EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476[/url]
> The links are dead links now. Figures.
> Can anyone help me?
> Thanks, Ross
>
>