大网数据广告活动
数据库与应用安全

SQL Server isn't supported on a Windows operating system on which case sensitivity is enabled

· 52CE 我爱测

This article describes the issue on Windows OS where 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) isn't a tested scenario for SQL Server. Additionally, this behavior isn't 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.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/06/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。