Article ID: 916766 - View products that this article applies to.
Bug #: 427770 (SQLBUDT)
When you try to install a SQL Server 2005 service pack, you may receive the following error message:
Note A SQL Server service pack refers to SQL Server 2005 Service Pack 1 (SP1) and later service packs.
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.
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:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 916766 - Last Review: October 17, 2006 - Revision: 3.1