Error message when you install or uninstall Microsoft SQL Server 2005 or SQL Server 2005 with Service Pack 2 or later versions on a Windows Vista-based or Windows Server 2008-based computer

Article translations Article translations
Article ID: 929150 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You install or uninstall the original release version of Microsoft SQL Server 2005 or SQL Server 2005 with Service Pack 2 (SP2) or later version on a Windows Vista-based or Windows Server 2008-based computer. After you do this, you receive an error message that resembles the following in the Microsoft SQL Server 2005 Setup dialog box:
The following applications should be closed before continuing the install:
SQL Server Agent (MSSQLSERVER) (Process Id:3956)
When you click Ignore in the dialog box, the installation is completed successfully.

If you use SQL Server 2005 Express Edition, SQL Server Agent may not be installed. In that case, the dialog shows "SQL Server" instead of "SQL Server Agent".

CAUSE

This issue occurs because of an enhanced file detection feature in Windows Vista and in Windows Server 2008. The enhanced file detection feature is known as Restart Manager. Restart Manager is used together with Microsoft Windows Installer version 4.0.

RESOLUTION

To resolve this issue, you can safely click Ignore in the Microsoft SQL Server 2005 Setup dialog box to continue the operation.

STATUS

This behavior is by design.

MORE INFORMATION

This problem does not occur if one of the following conditions is true:
  • You use the /quiet switch for the SQL Server 2005 installation.
  • You use the /qn switch for the SQL Server 2005 SP2 or later versions installation.
For more information about how to use Restart Manager together with Windows Installer version 4.0, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/aa372466.aspx

Properties

Article ID: 929150 - Last Review: November 20, 2007 - Revision: 1.6
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
Keywords: 
kbtshoot kbexpertiseadvanced kbsql2005setup kbprb KB929150

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