Difference between revisions of "Upgrading SQL"

From DLS5 Wiki
Jump to: navigation, search
(The Problem)
 
(2 intermediate revisions by 2 users not shown)
Line 2: Line 2:
  
  
'''The following instructions are CRITICAL !!!'''
+
==SQLite Confirm Database Deletion==
  
 +
When uninstalling DLS engine, user will be prompted a message to either delete or keep the database.  By default, 'Yes' is highlighted.  Please be vigilant of your selection if you are using keyboard keys.
  
'''''Windows XP users''''' should read this entire article before attempting to apply SQL Server Express 2005 SP3 upgrade.
+
[[Image:SQLite delete message.png]]
 
+
There is a known issue in the upgrade process of SQL Server Express 2005 SP3.  Please follow the steps below to successfully perform the upgrade.
+
 
+
 
+
==The Problem==
+
The SQL Server Express installer MAY fail when it detects a current (or newer) version of MSXML 6.0.  The solution is to remove the MSXML6.0 component before running the installation for SQL Server Express 2005 SP3.
+
 
+
This is the error that you will see when the SQL Server Express 2005 SP3 installation fails.
+
 
+
[[Image:SQLsp3InstallError.jpg]]
+
 
+
==How to Upgrade to Microsoft SQL Express 2005 SP3==
+
It is very important that the following instructions are executed in the proper order.  Any deviation from these steps may cause further complications and difficulty repairing the SQL installation.
+
 
+
 
+
===Use Microsoft Installer Cleanup Utility to Cleanup MSXML 6.0===
+
*Download the Cleanup Utility here:  http://support.microsoft.com/kb/290301
+
*Install and Run the Cleanup Utility
+
*Select MSXML6 Service Pack 2 (KB954459) [6.20.1099.0] in the list, and then click Remove.
+
 
+
[[Image:InstallerCleanupMSXML6.jpg]]
+
 
+
 
+
===Install Microsoft SQL Express 2005 SP3===
+
At this point, you can run the DLS IV Auto Updater installation again.  The DLS IV Auto Updater will automatically install SQL Server Express 2005 SP3.  Or you can manually download it and install.
+
 
+
SQL Server Express 2005 SP3 is available for download here:  http://www.microsoft.com/downloads/details.aspx?familyid=3181842A-4090-4431-ACDD-9A1C832E65A6
+
 
+
 
+
 
+
==More Information==
+
 
+
Read more information about this issue at the following locations
+
 
+
*Microsoft's official recommended recovery procedure:  http://support.microsoft.com/kb/968749
+
*Google Group - SQL Installation Trouble:  http://groups.google.com/group/flex-list/web/installation-problems-with-sql-server?pli=1
+

Latest revision as of 17:08, 14 December 2012


SQLite Confirm Database Deletion

When uninstalling DLS engine, user will be prompted a message to either delete or keep the database. By default, 'Yes' is highlighted. Please be vigilant of your selection if you are using keyboard keys.

SQLite delete message.png