You are currently offline, waiting for your internet to reconnect

BUG: The Installation Progress dialog box displays a status of Failure for the Database Services component when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 on an instance of SQL Server 2005

Bug #: 489459 (SQLBUDT)
SYMPTOMS
You configure an instance of Microsoft SQL Server 2005 to use a NTFS junction point to store data files. The NTFS junction point was created by using the Linkd.exe utility. When you install SQL Server 2005 Service Pack 1 (SP1) or SQL Server 2005 Service Pack 2 (SP2), the Installation Progress dialog box displays a status of Failure for the Database Services component. The other components are updated successfully.
CAUSE
This issue occurs because Microsoft Windows Installer removes the NTFS junction point during the installation process.
WORKAROUND
Note To avoid this issue when you install SQL Server 2005 SP1 or SQL Server 2005 SP2, see the "More Information" section.

To work around this issue, follow these steps.

Note This workaround assumes that you move all the data files of the instance from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to C:\SQLData\Data.
  1. Restart the computer.
  2. Re-create the junction point. To do this, follow these steps:
    1. Move the Data subfolder that is located in the C:\SQLData folder to a new folder. For example, move the Data subfolder to the C:\NewData foldt.
    2. Re-create the Data subfolder in the C:\SQLData folder.
    3. Delete all the files in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder.
    4. Run the following command at a command prompt:
      linkd.exe "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" " C:\SQLData\Data"
  3. Move all the files from the C:\NewData\Data folder to the C:\SQLData\Data folder.
  4. Start the SQL Server service.
  5. Set the permissions for the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL folder. To do this, follow these steps:
    1. Right-click the MSSQL folder, and then click Properties.
    2. In the Properties dialog box, click the Security tab.
    3. On the Security tab, click Advanced.
    4. In the Advanced Security Settings for MSSQL dialog box, double-click the Everyone user. If the Everyone user is not listed, click Add, type Everyone in the Enter the object name to select box, and then click OK.
    5. In the Permission Entry for MSSQL dialog box, click This folder and subfolders in the Apply onto list, and then click to select the Deny check box for the following permissions:
      • Delete Subfolders and Files
      • Delete
    6. Click to select the Apply these permissions to objects and/or containers within this container only check box, and then click OK.
    7. In the Advanced Security Settings for MSSQL dialog box, click OK. If you receive a warning message, click Yes.
  6. Add a new permission entry for the Everyone user to deny the Delete permission on the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder.

    To do this, follow these steps:
    1. Right-click the Data folder, and then click Properties.
    2. In the Properties dialog box, click the Security tab.
    3. On the Security tab, click Advanced.
    4. In the Advanced Security Settings for Data dialog box, click Add, type Everyone in the Enter the object name to select box, and then click OK.
    5. In the Permission Entry for Data dialog box, click This folder only in the Apply onto list, and then click to select the Deny check box for the Delete permission.
    6. Click OK three times. If you receive a warning message, click Yes.
  7. Install SQL Server 2005 SP1 or SQL Server 2005 SP2 again.
  8. After SQL Server 2005 SP1 or SQL Server 2005 SP2 is installed, delete the Everyone user on the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder.To do this, follow these steps:
    1. Right-click the Data folder, and then click Properties.
    2. In the Properties dialog box, click the Security tab.
    3. On the Security tab, click Everyone under Group or user names, and then click Remove.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
To avoid this problem when you install SQL Server 2005 SP1 or SQL Server 2005 SP2, perform step 5 and step 6 in the "Workaround" section before you start the installation. After the installation is complete, perform step 8 in the "Workaround" section.
Properties

Article ID: 932011 - Last Review: 12/12/2007 00:04:09 - Revision: 2.1

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Workgroup Edition
  • kbbug kbexpertiseadvanced kbtshoot kbsql2005setup kbprb KB932011
Feedback