Installation SQL Workstation Components on other nodes Priority 2
SQL Server 2005 installation on a cluster does not install all of the workstation components on the second node (or others, if in case). To complete this we need to logon on them and run the SQL Server 2005 setup program, but only install the Workstation Components.
This should be done, before applying any service pack to the SQL Server.
  • Logon to second node with domain administrator or equivalent.
  • Go to the disk location where the software is residing.
    Double click 'Splash.hta'
  • Click 'Server components, tools, Books Online, and Samples'
  • End User License Agreement:
    Select 'I accept the licensing terms and conditions'.
    Press Next
  • Installing Prerequisites:
    Press Next
  • SQL Server 2005 Setup:
    Press Next
  • System Configuration Check:
    Press Next
  • Registration Information:
    Press Next
  • Components to install:
    Select 'Workstation components, Books Online and development tools'.
    Press Next
  • Error and Usage Report Settings:
    Unselect all
    Press Next
  • Ready to Install:
    Press Install
  • Setup Progress:
    If everything is successful install, press Next
  • Completing Microsoft SQL Server 2005 Setup:
    Press Finish