Home Sitemap Feedback About... Print
Custom Search

SQL Server Troubleshooting


Installation

General info, best practices

SQL 2008 / 2008 R2

Known installation problems

SQL 2008 / 2008 R2 installation problems

  • 955763 - The SQL Server Agent service does not start after you upgrade from SQL Server 2008 Express or from SQL Server 2008 Express with Advanced Services to SQL Server 2008 Developer, to SQL Server 2008 Enterprise, or to SQL Server 2008 Standard
  • SQL Server 2005 and 2008 versions may not detect all available processors on a machine with more than 64 logical processors
  • 2251397 - SQL Server 2008 setup hangs on a x64 system with more than 32 logical processors
  • 2216465 - Slipstream installation of SQL Server 2008 fails if the /PCUSOURCE or /CUSOURCE has a space in the path
  • 2008982 - You are repeatedly prompted to restart the computer when installing SQL Server 2008
  • 2000225 - Error message when you install SQL Server 2008 Service pack 1 on systems upgraded from Windows 2003: "SQL server 2008 Setup requires Microsoft .NET framework 2.0 SP2 to be installed"
  • 970667 - SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: cusetfeatureinstallstateaction" error message
  • 970771 - SQL Server 2008 setup may fail with an unknown exception on MSVCR80.DLL
  • 981157 - The SQL Server 2008 installation fails and corrupts the SQL Server 2008 R2 installation
  • 958655 - Error message when you use Windows Installer (MSI) 4.5 to install multiple MSI packages in Windows Server 2008, Windows Vista, Windows Server 2003 or Windows XP: "API call rejected - No actions in Context" likely to be encountered during the installation of SQL Server 2008 or during an upgrade from SQL Server 2005 to SQL Server 2008
  • SQL server service pack installation may fail if your instance name is a Windows reserved word

Cluster installation errors

  • 953748 - Error message when you install SQL Server 2008 on a Windows Server 2008-based cluster: "The cluster either has not been verified or there are errors or failures in the verification report. Refer to KB953748 or SQL server books online"
  • 973992 - The default setting is used instead of the setting that is specified in the "Prepare Failover Cluster" stage when you perform an advanced cluster installation of a Microsoft SQL Server 2008 failover cluster
  • 2003488 - SQL Server failover installation fails when the setup account does not have permissions on Windows time service
  • 2216461 - SQL Server 2008 setup fails to install on a Windows Server 2008-based cluster mount point
  • 975951 - You receive an error message when you set up a SQL Server 2008 failover cluster on a subnet that only contains IPv6 addresses

SP / hotfix package installation problems

  • 2216468 - Error message when you try to install a SQL Server 2008 cumulative update or service pack: "The patch installer has failed to update the shared features"
  • 909652 - How to restore the missing Windows Installer cache files and resolve problems encountered during SQL Server update

Uninstalling previous versions / hotfix packages

  • 909967 - How to uninstall an instance of SQL Server 2005 manually
  • How do I remove previous versions of SQL Server 2005 / Whidbey? - on ASPFAQ.com
  • 921901 - BUG: You receive error code -2147024893 when you uninstall SQL Server 2005 Reporting Services on a computer that is running Windows Vista Beta 2 or Windows Server 2008
  • 915854 - You receive an error message when you try to uninstall the second named instance of SQL Server 2005
  • 955250 - Error message when you try to uninstall a SQL Server 2005 Express Edition hotfix package: "1731 The source installation package for the product [2] is out of sync with the client package"
  • 922209 - The SQL Server 2005 Setup program does not remove all IP address cluster resources when you uninstall SQL Server 2005
  • 909953 - How to uninstall SQL Server Management Studio
  • 2015126 - How to Uninstall SQL Compact 3.5 after installing SQL Server 2008
  • How to: Uninstall SQL Server Express
  • 922670 - How to use the Add or Remove Programs item in Control Panel to add or remove components for stand-alone installations and clustered installations of SQL Server 2005
  • 290301 - Description of the Windows Installer CleanUp Utility
  • How to uninstall an application when it does not appear in Add/Remove Programs - by Aaron Stebner