How to troubleshoot a failed upgrade to SQL Server 2008

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

SYMPTOMS

When you try to upgrade Microsoft SQL Server 2000 or Microsoft SQL Server 2005 to Microsoft SQL Server 2008, the upgrade operation fails. Additionally, you may receive the following error message:
The access control list is not in canonical form
If you try to upgrade again, all the options on the Select Features page are unavailable. Additionally, you receive the following error message in the status bar:
There are no features selected for upgrade

CAUSE

This problem occurs when a previous attempt to upgrade the instance of SQL Server 2000 failed and you try to upgrade again.

RESOLUTION

To resolve this problem, you must examine the summary log file and perform the actions that are specified under the Final Result entry. To do this, follow these steps:
  1. Locate the summary log file of the failed upgrade. Typically, the summary log file is located in the following folder:
    %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\
    The name of the summary log file resembles the following name:
    Summary_Server_Name-Node1_Date_Time.txt
  2. Open the summary log file, and then locate the Final Result entry. This entry specifies the actions that you must take to complete the upgrade. For example, you may see an entry that resembles the following entry:
    SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server using the following command line, and then rerun SQL Server Setup. Uninstall command line:
    setup /q /action=uninstall /instanceid=CLUSTER1 /features=SQLEngine,Replication,FullText
  3. Investigate and resolve the problem that caused the failure. Then, continue with the remaining steps.
  4. At the command prompt, move to the following folder:
    %Program Files%\Microsoft SQL Server\100\Setup Bootstrap
  5. At the command prompt, type the command that you identified in the Final Result entry in step 2, and then press ENTER. For example, if the Final Result entry resembles the example entry in step 2, type the following command, and then press ENTER:
    setup /q /action=uninstall /instanceid=CLUSTER1 /features=SQLEngine,Replication,FullText
  6. After the unistallation is complete, restart the upgrade to SQL Server 2008.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about the log files in SQL Server 2008, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/ms143702(SQL.100).aspx
For more information about SQL Server 2008, visit the following Microsoft Web site:
http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

Properties

Article ID: 955399 - Last Review: March 19, 2009 - Revision: 3.0
APPLIES TO
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
Keywords: 
sql2008relnotereadfirst sql2008relnoteupgrade sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kbtshoot kberrmsg kbprb KB955399

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