You are currently offline, waiting for your internet to reconnect

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

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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: 06/26/2013 15:58:00 - Revision: 1.0

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

  • kbsurveynew kbexpertiseadvanced kbinfo kbtshoot KB2860895
Feedback