Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 916766 - Last Review: October 17, 2006 - Revision: 3.1
Error message when you try to install a SQL Server 2005 service pack: "SQL Server Setup failed to modify security permissions on file Drive:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Data\ for user SYSTEM"
Bug #: 427770 (SQLBUDT)
When you try to install a SQL Server 2005 service pack, you
may receive the following error message:
Error 29506.
SQL Server Setup failed to modify security permissions on file
Drive:\Program Files\Microsoft SQL
Server\MSSQL.x\MSSQL\Data\ for user SYSTEM. To
proceed, verify that the account and domain running SQL Server Setup exist,
that the account running SQL Server Setup has administrator privileges, and
that exists on the destination drive.
A SQL Server service pack refers to SQL Server 2005 Service Pack 1 (SP1) and later service packs.
This problem occurs because one or more data files exist that do not have the required permissions. By default, the
Full
Control permission of the Administrators group is granted to the data
file when you create a database. If the permission of this group is removed
from the data file, the SQL Server 2005 service pack setup will
fail.
To resolve this problem, grant the
Full
Control permission to the Administrators group on all data files and on the Data folder. To grant the
Full
Control permission to the data files, follow
these steps:
- Locate the folder that contains the data files. By default,
these files are located in the following folder:
C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\
- Right-click the data file that has no required permissions
for the Administrators group, and then click
Properties.
- If the Administrators group is not in the
Group or user names list, click Add, type
Administrators, and then click
OK.
- Click Administrators in the Group or user
names list, and then click to select the Allow check
box for the Full Control item in the Permissions for
Administrators list.
Note If the files in the Data folder have an orphan owner, you have to take ownership of the files and then grant the
Full
Control permission to the files. We recommend that you do not change the default permissions for
the data files.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Workgroup Edition
| kbexpertiseadvanced kbtshoot kbsql2005setup kbprb KB916766 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate