Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. SQL Server is not supported on a Windows operating system on which case sensitivity is enabled

SQL Server is not supported on a Windows operating system on which case sensitivity is enabled

View products that this article applies to.

Introduction

Microsoft SQL Server is not supported on Windows operating systems on which case sensitivity is enabled.

↑ Back to the top

More Information

You can disable or enable Windows kernel case insensitivity by using the following registry key:

HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\kernel 
DWORD "obcaseinsensitive"

SQL Server relies on the Windows default value of 1 (one) for this key.

Note As soon as this key is set to 0 (zero) on a system on which SQL Server is installed, the operation of setting the key back to 1 (one) is not a tested scenario for SQL Server. Additionally, this behavior is not supported. Therefore, we recommend a clean reinstallation of SQL Server on a server on which this key has never been changed.

For more information, see How to configure case sensitivity for file and folder names.

↑ Back to the top

Keywords: kb, kbsurveynew, kbexpertiseadvanced, kbinfo, kbtshoot

↑ Back to the top

Article Info
Article ID : 2860895
Revision : 1
Created on : 1/7/2017
Published on : 6/26/2013
Exists online : False
Views : 412