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

Setup stops responding when you upgrade

· 52CE 我爱测

This article provides a resolution for the problem that occurs when you upgrade a SQL instance from one major version to another.

This article helps you resolve the problem that occurs when you upgrade an earlier version of SQL Server to SQL Server 2012.

Original product version:   SQL Server
Original KB number:   2712929

Symptoms

When you try to upgrade a SQL Server from one major version to another major version (for example, upgrading from SQL Server 2012 to SQL Server 2017), the Setup program seems to stop responding during the SQLEngineConfigAction_upgrade step.

When this issue occurs, setup information that resembles the following is logged at the end of the Detail.txt file:

(01) 2012-05-03 06:18:29 SQLEngine: --SqlEngineSetupPrivate: Setting Security Descriptor D:(<GUID value>) on Directory <Data directory>

(01) 2012-05-03 06:18:29 Slp: Sco: Attempting to set security descriptor for directory <Data Directory>, security descriptor D:( (<GUID value>))

(01) 2012-05-03 06:18:29 Slp: Sco: Attempting to normalize security descriptor D:( (<GUID value>))

(01) 2012-05-03 06:18:29 Slp: Sco: Attempting to replace account with sid in security descriptor D:( (<GUID value>))

(01) 2012-05-03 06:18:29 Slp: ReplaceAccountWithSidInSddl -- SDDL to be processed:  D:( (<GUID value>))

(01) 2012-05-03 06:18:29 Slp: ReplaceAccountWithSidInSddl -- SDDL to be returned:  D:( (<GUID value>))

(01) 2012-05-03 06:18:29 Slp: Sco: Directory <Data Directory>is a volume mount point. VolumeName is \\?\Volume{<VolumeID> }\

(01) 2012-05-03 08:27:50 Slp: Sco: Add DACL to underlying volume '\\?\Volume{<VolumeID }\' for directory '<Data directory>’from SDDL 'D:((<GUID value>))'

Note: The Detail.txt file is located in the folder: \Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log\timestamp.

Cause

This issue can occur if there are many subfolders and files that contain SQL Server data.

Note: This issue is more likely to occur if the database is integrated into the NTFS file system by using the FILESTREAM feature or the FILETABLE feature.

Resolution

No action is required to resolve this issue. To complete the upgrade, let the SQL Server 2012 Setup program finish.

More information

The issue that is described in the Symptoms section occurs because the SQL Server Setup program calls the SetSecurityInfo Windows API. The SetSecurityInfo API applies a discretionary access control list (DACL) to subfolders and files that contain SQL Server data. This process can take a long time to finish.

References

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 09/25/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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