all groups > sql server full text search > april 2006 >
You're in the

sql server full text search

group:

Full-Text Index Greyed out



Full-Text Index Greyed out Phill
4/18/2006 10:21:01 PM
sql server full text search: Hi, I am running SQL Server Standard on my development machine, Windows XP
Pro. I have restored my clients database into my SQL Server 2005 instance
(named SQLSERVER_2005) . I use a named instance because I still have SQL
Server 2000 and SQL Server 2005 Express instances running on the same
machine. I checked to make sure the SQL Server Full-Text Search (2005)
service was running; it is. i also ran this select
fulltextserviceproperty('isFulltextInstalled') and it return a 1, indicating
the service is running. I'm logged on SQL Management Studio as SA, also
tried using Window Auth, so I don't think it is a permissions problem.

I also tried to launch the sqlftwiz.exe from the Run menu, but it just
opened a black box with nothing in it.

Re: Full-Text Index Greyed out Hilary Cotter
4/19/2006 12:00:00 AM
You need to pass a server name, and an authentication method - for example
this works for me

sqlftwiz /usa /pMyPassword /s.\sql2000InstanceName

--
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



[quoted text, click to view]

Re: Full-Text Index Greyed out Ronan
4/2/2007 7:26:04 AM
Hi,

I am a complete novice but am trying to setup a full text index. I seem to
be having the same problem as mentioned below, bu how do i run this line and
is 'sql2000InstanceName' the same as the server IP address?

[SQL 2000 version 8, Windows NT 5.2]

Thanks for any help.

Ronan

[quoted text, click to view]
Re: Full-Text Index Greyed out Hilary Cotter
4/3/2007 10:40:14 AM
Use client network utility to build an alias. If this doesn't work put an
entry for the server name in your hosts file.

--
Hilary Cotter

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



[quoted text, click to view]

AddThis Social Bookmark Button