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

Article translations Article translations
Article ID: 932011 - View products that this article applies to.
Bug #: 489459 (SQLBUDT)
Expand all | Collapse all

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: December 12, 2007 - Revision: 2.1
APPLIES TO
  • 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
Keywords: 
kbbug kbexpertiseadvanced kbtshoot kbsql2005setup kbprb KB932011

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com