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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!