DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2860895 - Last Review: June 26, 2013 - Revision: 1.0

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 (http://technet.microsoft.com/en-us/library/cc725747.aspx) .

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
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support