You cannot crawl case-sensitive Web content in SharePoint Server 2007

In Microsoft Office SharePoint Server 2007, you add a content source to crawl Web content that resides on a computer that is not running Microsoft Windows. Additionally, the computer supports case-sensitive file names and case-sensitive folder names. When you search for crawled content in a folder that has a name that contains uppercase letters, the search query returns no results. For example, this problem occurs when you search for crawled content in a folder that is named FOLDERNAME.

Additionally, the crawl log contains an error message for each URL that contains an uppercase folder name or an uppercase file name. However, the URLs in the crawl log are displayed in lowercase letters.

How to obtain the hotfix

This issue is fixed in the SharePoint Server 2007 Hotfix Package that is dated April 12, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

How to obtain the hotfix

This issue is fixed in the Microsoft Windows SharePoint Services 3.0 Hotfix Package that is dated April 12, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

How to enable the hotfixes

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

1. Exit any programs that are running.
2. Click Start, click Run, type cmd, and then click OK.
3. At the command prompt, type net stop sptimerv3, and then press ENTER.
4. Click Start, click Run, type regedit, and then click OK.
5. Locate and then click the following registry key:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\GUID\Gather\Portal_Content
6. Double-click CaseSensitiveUrls, type 1 in the Value Data box, and then click OK.
7. Exit Registry Editor.
8. At the command prompt, type the following commands. Press ENTER after you type each command:
   • net stop osearch
   • net start osearch
   • net start sptimerv3

Note After you apply the hotfix and then set CaseSensitiveUrls to 1, you must reset the indexes. Then, you must recrawl the content.

Note Even if you apply and then enable this hotfix, the crawler always ignores URLs if the URLs differ from other items only in case. For example, if the crawler encounters "file\\Dir\File.docx" and then encounters "File:\\Dir\fILE.docx," the crawler ignores the second item.

How to determine the correct Shared Services Provider (SSP)

1. Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. Click Application Management.
3. Under Office SharePoint Server Shared Services, click Create or configure this farm's shared services.
4. Click the list next to the Shared Services Provider for which you want to enable case-sensitive crawling, and then click Edit Properties.
5. Next to the SSP Database section, note the Database Server value and the Database Name value, and then click Cancel.
6. Exit the Web browser.
7. Click Start, click Run, type regedit, and then click OK.
8. Locate and then click the following registry key:
   HKEY_LOCAL_MACHINE\Software\Microsoft\Office Server\12.0\Search\Applications
9. Expand the first GUID that is listed, and then click the ResourceManager subkey.
10. Compare the value of the Search subkey with the Database Server value and the Database Name value that you noted in step 5.
11. If the Database Server value and the Database Name value are the same as the value of the Search subkey, you have located the correct SSP.
12. If the Database Server value and the Database Name value differ from the value of the Search subkey, repeat steps 9 and 10 by using the next GUID that is listed under the HKEY_LOCAL_MACHINE\Software\Microsoft\Office Server\12.0\Search\Applications registry key.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.