Installing and upgrading to HP Insight Software 6.3 on Windows Server 2008 R2 Failover Cluster with SQL Server 2008 for high availability

Insta lling and upgrading HP Insight Softwa re
6.3
on Windows Server 2008 R2 Failover
Clusters with SQL Server 2008 for high
ava ila bility
Technical white paper
Table of contents
Revision history.................................................................................................................................... 4
Abstra ct .............................................................................................................................................. 4
Introduction ......................................................................................................................................... 5
Components supported in a highly-available environment ..................................................................... 7
Getting sta rted .................................................................................................................................... 9
Target audience ............................................................................................................................... 9
Hardware, software, storage, systems, and network requirements .......................................................... 9
Hardwa re .................................................................................................................................... 9
Softwa re ................................................................................................................................... 10
Stora ge ..................................................................................................................................... 10
Supporting Systems .................................................................................................................... 10
N etwork .................................................................................................................................... 10
Cluster configura tion ...................................................................................................................... 12
Setting up the failover environment ...................................................................................................... 12
Administrator credentials used by this white paper ............................................................................. 12
Installing and configuring prerequisites on both systems ...................................................................... 13
Insta lling Applica tion Server Role ................................................................................................. 13
Insta lling SN MP ......................................................................................................................... 14
Setting the SNMP service community name and security ................................................................. 14
Installing the ProLiant Support Pa ck ............................................................................................... 15
Activa ting the HP cluster MIB a gents ............................................................................................. 15
Creating the Failover Cluster ........................................................................................................... 16
Changing administrator accounts ..................................................................................................... 18
Installing the Microsoft SQL Server 2008 Enterprise ............................................................................... 18
Insta lling Microsoft Distributed Tra nsa ction Coordina tor a s a cluster service .......................................... 19
Installing Microsoft SQL Server 2008 Enterprise SP1 as a cluster service .............................................. 21
Crea ting a slipstrea m distribution ................................................................................................. 21
Alternative method for launching the SQL Server 2008 installer ....................................................... 21
Insta lling Microsoft SQ L Server 2008 Enterprise SP1 on the primary system ...................................... 21
Installing Microsoft SQL Server 2008 Enterprise SP1 on the secondary system ................................... 24
Applying updates to the SQL Server 2008 Enterprise Service Pack 1 ................................................ 25
Installing Insight Software components on the cluster .............................................................................. 26
Creating cluster group and resources for Systems Insight Manager and Insight Software ........................ 26
Insta lling Insight Softwa re prerequisites ............................................................................................. 27
Verifying the SQL Server clustered instance and determining port number in use ................................ 27
Verifying Insight Software prerequisites a nd upda ting W indows ...................................................... 28

Summary of content (71 pages)