Wednesday, December 10, 2008

Microsoft SQL Server installation errors and troubleshooting steps - 2000, 2005, 2008 32-bit 64-bit EM64 or IA64

General information and best practices articles in Microsoft Knowledgebase
907284 - Changes to the readme file for SQL Server 2005
910229 - SQL Server 2005 Express Edition Readme
905395 - A change to the Readme.htm file for SQL Server 2005 Mobile Edition
910070 - The SQL Server 2005 Setup program may take a very long time to be completed
916760 - How to copy the files from the SQL Server 2005 installation CDs to a location and how to start the SQL Server 2005 Setup program from that location
915846 - Best practices for setting up domain groups when you install a SQL Server 2005 cluster
910230 - How to install SQL Server 2005 Analysis Services on a failover cluster
910233 - Migrate a SQL Server 2000 Analysis Services cluster to a SQL Server 2005 Analysis Services cluster
934164 - How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
918481 - How to install Microsoft Operations Manager (MOM) 2005 Service Pack 1 databases and MOM 2005 Reporting on a computer that has Microsoft SQL Server 2005 installed
924000 - How to upgrade the initial release of Windows Small Business Server 2003 R2 to include the final release version of SQL Server 2005 Workgroup Edition
926824 - How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring
941232 - How to apply a hotfix for SQL Server 2005 in a replication topology

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 '\SQLServer2005MSSQLUser$$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$"
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 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

No comments:

Post a Comment

Please do not spam!