How to update SQL 2005 SP2 to SQL 2005 SP4

Question

  • 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

Answer/StepsInstructions

  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.
    1. See Daktronics KB reference DD3358611, How to Run the SQL 2014 Upgrade Check for more information.
  4. Stop the SQL Server (NUCLEUS) service in the Services dialog (Start Menu -> type services.msc -> press Enterupdate 1.pngMachine generated alternative text:  Services   File Action View Help   Services (Local)   SQL Server (NUCLEUS)   Stat the service   Description:   Provides storage, processing and   controlled access of data and rapid   transaction processing.   SNMP Trap   Software Protection   SPP Notification Service   SQL Server (NUCLEUS)   SQL Server Active Directory Helper   SQL Server Browser   SQL Server VSS Writer   SSDP Discovery   Storage Service   Description   Receives tra...   Enables the .   Provides So...   Prcvides Etc...   Enables Inte...   Provides SQ...   Provides th...   Discovers n...   Enforces gr...   Status   Stated   Stated   Stated   Startup Type   Manual   Automatic (D...   Manual   Autcmatic   Disabled   Automat ic   Automatic   Manual   Manual   Extended   Standard
  5. Start the SQL Server 2005 Express SP4 installer.
    1. http://dakfiles.daktronics.com/downloads/installshield/sql2005/SQLEXPR2005SP4.EXE
    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


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.