fts SQL Server Personal on XP Pro

Hi,
I have SQL Server 2000 Personal edition installed on XP
Pro and am trying to implement the full-text search
facility. There doesn't seem to be any option to install
fts on my SQL Server CD so I assumed it should be
installed by default.
However, when I try
EXEC sp_fulltext_database @.action = 'Enable'
I get the following error
erver: Msg 7609, Level 17, State 2, Procedure
sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text
component cannot be loaded.
Is FTS possible with this version of SQLServer?
thanks
Maracatu
maracatu,
No, the SQL Server 2000 "Full-Text Search" components are not supported with
the Personal Edition. See SQL 2000 BOL title "Features Supported by the
Editions of SQL Server 2000" for editions that support SQL FTS.
Regards,
John
"maracatu" <jarrod@.dovelight.com> wrote in message
news:1ccfa01c42241$c5b48fe0$a101280a@.phx.gbl...
> Hi,
> I have SQL Server 2000 Personal edition installed on XP
> Pro and am trying to implement the full-text search
> facility. There doesn't seem to be any option to install
> fts on my SQL Server CD so I assumed it should be
> installed by default.
> However, when I try
> EXEC sp_fulltext_database @.action = 'Enable'
> I get the following error
> erver: Msg 7609, Level 17, State 2, Procedure
> sp_fulltext_database, Line 46
> Full-Text Search is not installed, or a full-text
> component cannot be loaded.
> Is FTS possible with this version of SQLServer?
> thanks
> Maracatu
|||Hmmmm.... This article on MSDN says that Full Text IS supported on Personal Edition...
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||SqlJunkies User,
Hmmm is right... Actually we both referenced the same doc (your MSDN
reference is the same info that is in the SQL BOL reference I quoted...
However, the initial poster may need to specifically install the SQL FTS
components via the SQL CD's "custom installation" and select the "Full-text
Search" components in order to install it. I've not tested this myself as I
don't use the Personal Edition of SQL Server on WinXP as I use the Developer
Edition. If you have the Personal Edition, perhaps you could test this
yourself and post the results here... ;-)
Regards,
John
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:#W##QXpREHA.1276@.TK2MSFTNGP11.phx.gbl...
> Hmmmm.... This article on MSDN says that Full Text IS supported on
Personal Edition...
>
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||I had the exact same problem. I found and posted the article mentioned in the last post. I then found article Q827449 that tells how to reinstall Full Text by running some stuff on the SQL CD. I followed all the instructions, but didn't seem to make it
work. Something still missing. Then, when running the Setup for SQL 2000 Personal Edition again (Not uninstalling my first one), and choosing a Custom Install to Add/Remove components, the option for Full Text was already checked. It would not let me
uncheck it (Setup didn't recognize that I had changed anything and wouldn't continue). Finally, had to uninstall, whack all SQL related registry keys, and reinstall. On the reinstall, chose Custom Install. Full Text is NOT checked by default. Checked
it, and finished the install. Full Text is now available and usable on my SQL 2000 Personal Edition on XP Professional. If you haven't "damaged" you SQL install by following Q827449, you might be able to add it by running Setup again and choosing Custo
m Install to Add/Remove Components...
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||Hi,
In order to un-check the option for Full Text Search that was already
checked, you must delete or rename the following Tracking Key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Note, if your SQL Server 2000 is not a named instance, remove
"<Instance_Name>\" and be sure to be logged on to the server as either
Administrator or as a member of the server's Admin Group.
Once you've done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, you should post
these files.
I'm not sure why the procedures in Q827449 failed for you, but if you follow
the above procedures, it will always work as I've posted the above methods
many, many times in this newsgroup (microsoft.public.sqlserver.fulltext) and
always with successful results.
Regards,
John
<CSaalfeld@.-NOSPAM-Earthlink.net> wrote in message
news:OEdOfICSEHA.3052@.TK2MSFTNGP12.phx.gbl...
> I had the exact same problem. I found and posted the article mentioned in
the last post. I then found article Q827449 that tells how to reinstall
Full Text by running some stuff on the SQL CD. I followed all the
instructions, but didn't seem to make it work. Something still missing.
Then, when running the Setup for SQL 2000 Personal Edition again (Not
uninstalling my first one), and choosing a Custom Install to Add/Remove
components, the option for Full Text was already checked. It would not let
me uncheck it (Setup didn't recognize that I had changed anything and
wouldn't continue). Finally, had to uninstall, whack all SQL related
registry keys, and reinstall. On the reinstall, chose Custom Install. Full
Text is NOT checked by default. Checked it, and finished the install. Full
Text is now available and usable on my SQL 2000 Personal Edition on XP
Professional. If you haven't "damaged" you SQL install by following
Q827449, you might be able to add it by running Setup again and choosing
Custom Install to Add/Remove Components...
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.