Daktronics

How to update SQL 2005 SP2 to SQL 2005 SP4

Topic

  • How do I update SQL 2005 SP2 to SQL 2005 SP4?

Environment

  • Show Control - Installs prior to May 2012 (Display Studio v1.17)
  • Microsoft SQL Server 2005 was never updated to SP4
  • Upgrade to SQL Server 2014 fails due to unsupported version

Steps

  1. Backup the Nucleus database on the server.
    Note: No need to backup database on client.
  2. Make sure all the latest Windows updates have been installed.
  3. If the state of the system is unknown, run the SQL 2014 Upgrade Utility to determine if these steps are necessary.
  4. Stop the SQL Server (NUCLEUS) service in the Services dialog (Start Menu -> type services.msc -> press Enter
    update201.png 
  5. Start the SQL Server 2005 Express SP4 installer.
    1. https://www.catalog.update.microsoft.com/Home.aspx/  - From the update catalog, search for SQL Server 2005 Express SP4
    2. Accept the License Agreement and click Next
      update 2.png
    3. Click Install when prompted.
      update 3.png
    4. Verify Microsoft SQL Native Client and Microsoft SQL Server 2005 Setup Support Files were installed successfully and click Next >.
      update 4.png
    5. After the computer configuration is scanned the SQL Server Installation Wizard will open. Click Next >
    6. Verify the System Configuration Check is successful and click Next >
      update 5.png
    7. Set the name (default name is fine), and uncheck Hide advanced configuration options. Click Next >
      NOTE: Hide advanced configuration options must be unchecked for a proper installation.
      update 6.png
    8. Select all features to be installed and click Next >
      update 7.png
    9. If not selected, Select Named instance.
    10. In the text box, enter NUCLEUS or click Installed instances and select SQL Server (NUCLEUS). Click Next >
      update 8.pngupdate 9.png
    11. Select SQL Server Database Services 9.2.2042.00 and click Next >
      update 10.png
    12. Leave Windows Authentication Mode selected and click Next >
      update 11.png
    13. Leave the default selections for the Configuration Options and click Next >
      update 13.png
    14. Leave the default selections for the Error and Usage Report Settings and click Next >
      update 12.png
    15. Click Install.
      Note:       If prompted to stop the SQL Server (NUCLEUS) service, stop the service (see step 9) and click Retry
    16. Verify the setup is finished for each product and click Next >>
      update 14.png
    17. Click Finish to complete the SQL Server Express 2005 SP4 update.
  6. Display Studio may be installed normally now.

KB ID: DD3340172

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.