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

Article translations Article translations
Article ID: 2860895 - View products that this article applies to.
Expand all | Collapse all

Introduction

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

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.

Properties

Article ID: 2860895 - Last Review: June 26, 2013 - Revision: 1.0
Applies to
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Community Technology Preview
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Integration Services
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
Keywords: 
kbsurveynew kbexpertiseadvanced kbinfo kbtshoot KB2860895

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com