You may receive an error message when you try to install SQL Server 2005 Service Pack 1 (916766)
The information in this article 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
Bug #: 427770 (SQLBUDT)
SYMPTOMSWhen you try to install Microsoft SQL Server 2005 Service Pack 1 (SP1), 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. CAUSEThis 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, SQL Server 2005 SP1 setup will
fail.RESOLUTIONTo 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. STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
| Modification Type: | Major | Last Reviewed: | 6/21/2006 |
|---|
| Keywords: | kbExpertiseAdvanced kbtshoot kbsql2005setup kbprb KB916766 kbAudITPRO |
|---|
|