SQL Server installation troubleshooting, interesting articles
General info, best practices
| |
| |
Known installation problems
Upgrade errors
- 876234 - How to troubleshoot the installation of SQL Server 2008 CTP or the upgrade to SQL Server 2008 CTP
- 914158 - You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005
- 936892 - Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy"
- 953741 - SQL Server 2005 installers stop dependent services
- 953739 - SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled state
Vista and Windows 2008 installation errors
- 936302 - List of known issues when you install SQL Server 2005 on Windows Server Code Name "Longhorn"
- 920201 - You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server "Longhorn"
- 929105 - Error message when you install SQL Server 2005 Express Edition Service Pack 1 in Windows Vista: "Windows NT user or group '<COMPUTERNAME>\SQLServer2005MSSQLUser$<COMPUTERNAME>$MSSQLSERVER' not found"
- 929150 - Error message when you install or uninstall Microsoft SQL Server 2005 or SQL Server 2005 with Service Pack 2 on a Windows Vista-based or a Windows Server Longhorn-based computer
- 934750 - Some shared components are not installed in the correct folder when you install SQL Server 2005 Express Edition on a computer that is running a 64-bit version of Windows Vista
- 938245 - How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"
- 947986 - Error message when you install SQL Server 2005 on a Windows Server 2008-based RODC: "Failure creating local group SQLServer2005SQLBrowserUser$<ServerName>"
- 948210 - Problems occur in Windows Server 2008 after you uninstall a SQL Server 2005 failover cluster, or after you install SQL Server 2005 Service Pack 2 or a Service Pack 2-based hotfix on a SQL Server 2005 failover cluster
- 955966 - SQL Server Compact 3.5 Service Pack 1 Server Tools are not installed in WOW mode when you run IIS 7.0 on a 64-bit Windows Server 2008-based computer or on a 64-bit Windows Vista-based computer
Express Edition installation errors
- 921110 - Error message when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Express Edition: "Another installation is already in progress. Complete that installation before proceeding with this install"
- 919392 - Error message when you try to install SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services: "Server SQL Server is terminating because of fatal exception c000001d"
- 920114 - Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start"
- 929589 - Error message when you install SQL Server 2005 Express Edition with Advanced Services: "SQL Server Setup failed to retrieve the SSL Certificate Name"
- 933833 - BUG: Error message when you install SQL Server 2005 Express Edition with Advanced Services: "An installation package for the product Microsoft SQL Server Native Client cannot be found"
Mobile / Compact Edition installation issues
- 909751 - The NorthwindOleDb sample application is not available when you install SQL Server Mobile Edition from a SQL Server 2005 installation
- 945317 - A file and some registry entries are missing when you upgrade SQL Server Compact 3.5 Beta to SQL Server Compact 3.5
64-bit installation errors
- 907261 - BUG: Installation may fail, and you may receive an error message when you try to install SQL Server 2005 64-bit on a 64-bit server
- 908454 - You cannot upgrade a named instance of SQL Server 2000 to SQL Server 2005 on a computer that is running the Itanium-based operating system
- 936491 - After you install a 64-bit version of SQL Server 2005 on a 64-bit version of Windows, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager
- 937684 - You may be prompted to restart the computer after you install the 64-bit version of SQL Server 2005 Service Pack 2 even if the Setup program does not report that some components are locked
Cluster installation errors
- 910851 - You receive error messages when you try to set up a clustered instance of SQL Server 2005
- 913815 - Error message when you install a SQL Server 2005 failover cluster on a node: "The drive specified cannot be used for program location"
- 926621 - Error message when you try to install SQL Server 2005 in a cluster environment: "SQL Server Setup could not validate the service accounts"
- 934749 - BUG: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> been patched with more recent updates"
- 943525 - You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server build is 3179 or a later build
- 945937 - The SQL Server 2005 Setup program generates an incorrect error message when you install a SQL Server 2005 failover cluster and the Setup program cannot access the cluster resource
- 948208 - An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server 2005 on a Windows Server 2008-based server
- 948210 - Problems occur in Windows Server 2008 after you uninstall a SQL Server 2005 failover cluster, or after you install SQL Server 2005 Service Pack 2 or a Service Pack 2-based hotfix on a SQL Server 2005 failover cluster
SP / hotfix package installation problems
- 925976 - Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: "Error 29528. The setup has encountered an unexpected error while Setting Internal Properties"
- 929151 - A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005
- 932011 - 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
- 932012 - Only the "Backward Compatibility" component is selected on the "Feature Selection" page when you install a localized version of SQL Server 2005 SP2
- 932869 - Error message when you install SQL Server 2005 Service Pack 1 on an instance of SQL Server 2005 when the computer is also running an instance of SQL Server 2005 Service Pack 2: "SqlSupport.msp is not digitally signed"
- 934652 - You cannot install SQL Server 2005 Service Pack 2 on a computer that is running SQL Server 2005 Reporting Services after you install the .NET Framework 2.0
- 935297 - SQL Server Setup fails unexpectedly when you try to install SQL Server 2005 Service Pack 2
- 935371 - Error message when you install SQL Server 2005 SP2, SQL Server Express SP2, or SQL Server Express with Advanced Services SP2: "SQL Server Setup failed to execute a command for server configuration. CREATE DATABASE failed"
- 936488 - When you install a SQL Server 2005 service pack or a SQL Server 2005 hotfix, the installation stops unexpectedly
- 940971 - SQL Server 2005 Service Pack 2 installation fails, and a "The Transaction Manager is not available" error message is logged in the Summary.txt file
- 947988 - You cannot install SQL Server 2005 Service Pack 1 on a SQL Server 2005 failover cluster if the failover cluster is behind a firewall
- 947989 - You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database
- 957008 - SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall security update KB948108 or security update KB948109
Misc. installation errors
- 908503 - Description of the "Error 1619 installing sqlncli.dll" error message that you may receive when you install SQL Server 2005
- 911936 - The installation may fail and you may receive an error message when you try to install the DTS redistributable package for SQL Server 2005 on a Windows 2000 Advanced Server SP4-based computer
- 917827 - Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"
- 918685 - Error message when you install SQL Server 2005: "The file C:\Windows\Microsoft.NET\Framework\Meaningless_string\mscorlib.tlb could not be loaded"
- 919398 - Error message when you try to install SQL Server 2005: "Could not find a package to install on the installation media"
- 919944 - Error message when you try to modify or reinstall the existing installation of SQL Server Native Client: "The file 'Folder\sqlncli.msi' is not a valid installation package for the product Microsoft SQL Server Native Client"
- 921902 - You receive a "Sample database 'Adventureworks' already exists in SQL instance specified" error message when you use Add or Remove Programs to install the AdventureworksDW Sample Data Warehouse sample database in SQL Server 2005
- 922669 - Error message when you install SQL Server 2005 on a computer that is running the original release version of Windows XP: "This application has failed to start because the application configuration is incorrect"
- 927230 - You may receive an error message when you try to install the UDDI Services database components on an instance of SQL Server 2005 that is running on a Windows Server 2003-based computer
- 933945 - Issues that you may encounter when you install a named instance of one or more SQL Server 2005 components and specify different installation locations for one or more of the components
- 934012 - Error message when you try to install SQL Server 2005 on a volume mount point: "There is not enough space on the destination disk for the current SQL Server installation"
- 945935 - Error message when you install the WOW version of SQL Server 2005 on a 64-bit operating system: "Windows Installer has stopped working"
- 948907 - You receive error messages after you uninstall SQL Native Client from a server that is running SQL Server 2005
- 954835 - You cannot install SQL Server 2005 on a server when the number of processors of the server is not a power of 2
- 955500 - Error message when you try to install an instance of SQL Server 2005 on a computer that has an instance of SQL Server 2008 already installed: "An instance with the same name is already installed on this computer"
Uninstalling previous versions / hotfix packages
- 290991 - How to manually remove SQL Server 2000 default, named, or virtual instance
- 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
- 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
- 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