Full text search installed but ni languages supported :(

Hi,

I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

Hi Ikeer,

Fulltext Search is not installed by default. You should confirm that you actually selected if from the feature list when you installed it. If you just took the defaults (i.e. clicked Next until you finished) you didn't install it. You'll need to launch maintenance mode from Add/Remove Programs and select Fulltext Search from the feature tree.

Mike

|||

Hi Mike,

Yes, I know i installed the Fullsearch text but still i do not get languages. I follow the same step's in my other computer and it worked in that one, the only difference between the two systems is that i installed the SQL sever 2005 beta in the one that is failing. I realized that and read that it need it to be removed so i removed the SQL server 2005 and then went to a link that i found here and it remove the beta. I double check and the application told me that they were not traces of the Beta products. I though that would work now.. but it did not.. when i reinstalled the SQL server 2005 i had no languages :(. I gave up and worked remotely in my other computer. I would love to know what is preventing me from install the SQL Server because i dont want to reinstall everything.. it's like 20hrs :(. anyway any help would be appriciate.

Thank you.

|||

Hi!

Did you try actualy running a FT query? does it work? try selecting a language at query time different than neutral or English?

If it worked in other computer with Express, it might be because that other computer is using the OS WordBreakers and SQL Server is loading them. It seems that this is not happening in your instance (you dont see the installed ones nor the OS ones). Let me investigate more and come back when I get more answers.

Thanks.

|||

Did this resolve the issue?

Mike

|||

Hi again guys,

We need to be sure that FTS was installed correctly. Please do the following:

-Go to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language

And let me know which folders/languages are you seeing there. If you don't see any, then it is not correctly installed, if you see them, please forward them to me and we will investigate here what is going on.

you can reply me as well to fernlope@.microsoft.com

Thanks!

|||

Hi i went to that key and saw many folders, inside the language there is a ke call default type REG_SZ Data value not set

then there are many folders

chs

cht

deu

eng

enu

esn

fra

ita

jpn

kor

neutral

nld

sve

tha

zh-hk

zh-mo

zh-sg

by the way, ansering if i tried to run the Full text search query, i did not since it wont let me create the full search in the table.

P.S i also had sql server 2000 install but i unisntalled it way before install the SQL server 2005

Thank you for your help

|||

I am having the exact same problem as Ikeer described above. I did not previously have any SQL Server installed on the computer. I do have MS Visual Studio 2005 Professional installed, but did not elect to install SQL server from that setup. Has there been any new info on this? I tried reinstalling just FTS for my instance, but that didn't seem to help.

sql