Licensed third-party word breakers are not installed by default in SQL Server 2005 Community Technology Preview September 2005

Microsoft SQL Server 2005 Community Technology Preview (CTP) September 2005 includes licensed third-party word breakers for the following languages:

• Danish
• Polish
• Portuguese-Brazilian
• Portuguese-Iberian
• Russian
• Turkish

These word breakers are available. However, they are not installed by default in SQL Server 2005 CTP September 2005. Therefore, you must manually register these word breakers.

Note We recommend that you set the Microsoft Full-Text Engine for SQL Server (MSFTESQL) service to run under a low-privileged account.

Register the word breakers

To register a word breaker, you must use the following method:

• Add the following information to the
  <InstanceRoot>\MSSearch\CLSID
  registry subkey:
  • The Microsoft Component Object Model (COM) Class ID or Class IDs for the word breaker
  • The stemmer interfaces for the language that you are using
  Note <InstanceRoot> represents the instance root.
• Add a subkey to the
  <InstanceRoot>\MSSearch\Language
  registry subkey for the language.
• Add configuration values that specify the location of the lexicon, noise word, and thesaurus files for the language.

Obtain instance IDs for multiple instances of SQL Server

The registry paths that are listed in this article are for the first instance of SQL Server 2005. This instance has instance ID MSSQL.1. If multiple instances of SQL Server exist, you must modify the registry paths by substituting the instance ID for that instance instead of MSSQL.1. To obtain the instance ID for an instance, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate the following registry key for the first instance of SQL Server:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
3. In the right pane, the instance names and the corresponding instance IDs appear.

Obtain the instance-specific FTData folder path

After you obtain the instance IDs, you must obtain the appropriate instance-specific path of the FTData folder. You will use this path when you add configuration values that specify the lexicon, noise word, and thesaurus files for a language. To obtain the instance-specific FTData folder path, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key for an instance of SQL Server:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance ID>\MSSQLServer
   Note <Instance ID> is MSSQL.1 for the first instance of SQL Server. Therefore, the registry key will be the following:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
3. In the right pane, the FullTextDefaultPath registry value appears. This value contains the instance-specific path of the FTData folder. For example, the instance-specific path for the first instance may be C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData.

Install the word breakers

The following section describes how to install the word breakers for the following languages:

• Danish
• Polish
• Portuguese-Brazilian
• Portuguese-Iberian
• Russian
• Turkish

Note The following steps use the Danish word breaker as an example. The values that you must use to install other language word breakers are listed after each step.

Add the COM Class ID or Class IDs for the word breaker, and add the stemmer interfaces for the language that you want to use

To add a COM Class ID or Class IDs for these components, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key for the first instance of SQL Server:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\CLSID
3. On the Edit menu, point to New, and then click Key.
4. Type {16BC5CE4-2C78-4CB9-80D5-386A68CC2B2D}, and then press ENTER.
5. In the right pane, right-click the Default registry value, and then click Modify.
6. In the Edit String dialog box, type danlr.dll in the Value data box, and then click OK.
7. On the Edit menu, point to New, and then click Key.
8. Type {83BC7EF7-D27B-4950-A743-0F8E5CA928F8}, and then press ENTER.
9. In the right pane, right-click the Default registry value, and then click Modify.
10. In the Edit String dialog box, type danlr.dll in the Value data box, and then click OK.

For other languages, use the registry key values that are listed in the following table. In step 6 and in step 10, replace danlr.dll with the DLL for the language that you want.

Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language

To add a subkey to this registry subkey, follow these steps:

1. Locate and then click the following registry key for the first instance of SQL Server:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language
2. Repeat steps 3 through 4 in the "Add the COM Class ID or Class IDs for the word breaker, and add the stemmer interfaces for the language that you want to use" section. Replace the key name in step 4 with dan.
   
   For other languages, replace the key name in step 4 with the value that is listed in the following table.
   Collapse this tableExpand this table

   Language	Key name
   Polish	plk
   Portuguese-Brazilian	ptb
   Portuguese-Iberian	pts
   Russian	rus
   Turkish	trk

Add configuration values that set the location of the lexicon, noise word, and thesaurus files for the language

To add configuration values for these components, follow these steps:

1. Locate and then click the registry key that you added in the "Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language" section. For the first instance of SQL Server, this registry key would be the following:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language\dan
2. On the Edit menu, point to New, and then click String Value.
3. Type NoiseFile, and then press ENTER.
4. Right-click the NoiseFile registry value, and then click Modify.
5. In the Edit String dialog box, type Instance-SpecificFTDataPath\noisedan.txt in the Value data box.
   
   Note InstanceSpecificFTDataPath represents the path that you obtained by following the steps in the "Obtain the instance-specific FTData folder path" section.
6. Click OK.
7. Repeat steps 2 through 6 to add the values that are listed in the following table for the Danish language.
   Collapse this tableExpand this table

   Value type for step 2	Value names for step 3 and step 4	Value type for step 5
   String value	TsaurusFile	Instance-SpecificFTDataPath\tsdan.xml
   DWORD value	Locale	00000406
   String value	WBreakerClass	{16BC5CE4-2C78-4CB9-80D5-386A68CC2B2D}
   String value	StemmerClass	{83BC7EF7-D27B-4950-A743-0F8E5CA928F8}

For languages that differ from Danish, use the following values.

Polish language values

Locate and then click the registry key that you added in the "Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language" section. For the first instance of SQL Server, this registry key would be the following:Follow the steps in the "Add configuration values that set the location of the lexicon, noise word, and thesaurus files for the language" section by using the values in the following table.

Portuguese-Brazilian language values

Locate and then click the registry key that you added in the "Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language" section. For the first instance of SQL Server, this registry key would be the following:Follow the steps in the "Add configuration values that set the location of the lexicon, noise word, and thesaurus files for the language" section by using the values in the following table.

Portuguese-Iberian language values

Locate and then click the registry key that you added in the "Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language" section. For the first instance of SQL Server, this registry key would be the following:Follow the steps in the "Add configuration values that set the location of the lexicon, noise word, and thesaurus files for the language" section by using the values in the following table.

Russian language values

Locate and then click the registry key that you added in the "Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language" section. For the first instance of SQL Server, this registry key would be the following:Follow the steps in the "Add configuration values that set the location of the lexicon, noise word, and thesaurus files for the language" section by using the values in the following table.

Turkish language values

Locate and then click the registry key that you added in the "Add a subkey to the <InstanceRoot>\MSSearch\Language registry subkey for the language" section. For the first instance of SQL Server, this registry key would be the following:Follow the steps in the "Add configuration values that set the location of the lexicon, noise word, and thesaurus files for the language" section by using the values in the following table.