Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
Permalink
main
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

SupportArticles-docs/support/sql/database-engine/install/windows/sql-server-not-supported-in-windows-os-where-case-sensitivity-enabled.md

Go to file
 
 
Cannot retrieve contributors at this time
28 lines (20 sloc) 1.35 KB
Raw Blame
Open in GitHub Desktop
title description ms.date ms.custom ms.author ms.topic ms.prod
SQL Server is not supported on a Windows operating system on which case sensitivity is enabled
This article describes the issue on Windows OS where case sensitivity is enabled.
09/21/2022
sap:Database Design and Development
v-jayaramanp
troubleshooting
sql

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

Original product version:   SQL Server 2012, SQL Server 2008, SQL Server 2005
Original KB number:   2860895

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

Path: HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\kernel
Value name: obcaseinsensitive
Value type: DWORD

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.