Deploying HP SIM 5.x on MSCS clusters on Windows 2008 with SQL Server 2005 Table of Contents Abstract.............................................................................................................................................. 3 Introduction......................................................................................................................................... 3 Installing HP SIM on Windows 2008 failover cluster with SQL Server 2005 .........................................
Microsoft SQL Server 2005 Enterprise Edition ................................................................................... 52 HP SIM 5.x ...................................................................................................................................
Abstract This white paper is intended to assist IT professionals in installing HP Systems Insight Manager (HP SIM) 5.x in a Microsoft Cluster Server configuration. Microsoft Windows 2008 Enterprise Server with HP SIM 5.x can be a simple way of obtaining redundancy and failover capability from this powerful management software. Introduction HP SIM 5.
Figure 1: The relationship between HP SIM 5.x, SQL Server 2005, and the cluster disks Installing HP SIM on Windows 2008 failover cluster with SQL Server 2005 If you are installing HP SIM 5.x into an environment without a Microsoft SQL Server 2005 Enterprise Edition instance already installed, go to for steps to install a clustered named instance of Mi crosoft SQL Server 2005 Enterprise Edition. This named instance can host the HP SIM 5.
The secondary system is for running the HP SIM 5.x service and all the component services it requires. Storage configuration Figure 1 displays the relationship between Microsoft SQL Server 2005 Enterprise Edition instances and HP SIM 5.x. At least two logical drives must be available in the shared storage if your infrastructure does not have Microsoft SQL Server installed to which you can attach the HP SIM 5.x database.
– Function: To serve as the TCP/IP address and name of the specific Microsoft Windows server host. – Suggested action: Any software that references system-specific functions uses this address to connect to this system. For the examples shown in this paper, the IP address is 140.110.240.61.
Note: SNMP Services must be installed for Windows 2008. 6. Insert the Microsoft Windows 2008 Enterprise Server CD into the CD-ROM drive of the target server. 7. Select Start>Settings>Control Panel. 8. Click Add/Remove Programs. 9. Click Add/Remove Windows Components. 10. Select Management and Monitoring Tools in the Windows Component Wizard window. 11. Click Details. Then select Simple Network Management Protocol if it is not selected by default. 12. Click OK. The Windows Component Wizard window appears.
Note: This section assumes that you already have a working two-system cluster with at least two free logical drives, one for the Microsoft SQL Server 2005 data files and another for the HP SIM 5.x program files. Installing a clustered instance of the Microsoft SQL Server 2005 Enterprise Edition 1. Insert the Microsoft SQL 2005 Extended Edition CD into your CD-ROM drive. This paper assumes that the SQL Server 2005 Installation setup window opens automatically. 2. Click Install. The installation begins.
Figure 3: Required components installed successfully 5. After the configuration check is complete on all systems, a summary appears. Review any warning or error messages and correct any issues until there are no messages in the Summary window.
Figure 4: System Configuration Check 6. Click Next. The Microsoft SQL server installation window appears. 7. Click Next. 8. Enter registration information and enter a valid product ID. 9. Select components to install in the Components to install window. Available components include Database services, Create SQL server Failover Cluster, Workstation components, books Online, and development tools.
Figure 5: Components to Install 10. Click Advanced to ensure that Management Tools is selected. Note: The Management Tools option is not installed by default and must be selected. 11. Select Management Tools from client tools in the Feature selection window.
Figure 6: Feature selection 12. Click Next. The Instance name window appears. 13. Select Name Instance and enter one instance name. Note: Common instance name is required to install HP SIM and fail over for HP SIM. 14. Click Next. 15. Enter the Virtual Server name (SQL-SRV).
Figure 7: Virtual Server Name 16. Click Next. The Virtual Server Configuration window appears. 17. Enter the Virtual Server IP address.
Figure 8: Virtual server information Note: If the system you are installing on is a two node MSCS box with a private and public network, you must select public when assigning a new public IP address to the SQL 2005 Virtual Server IP address. This can be selected in the Network to use field on the Virtual Server Configuration window. 18. Click Next after you have entered the Client Access Point (CAP) information. The Cluster Group Selection window appears. 19.
Figure 9: Cluster Group Configuration 20. Click Next. The Cluster Node Configuration window appears. By default the installation program assumes that all nodes are part of the cluster. In this e xample, we have two nodes that must have SQL Server 2005 installed and participate as part of the SQL clustered instance. Note: Be sure that in the selected nodes section, the second node of the cluster and in required node with localhost (current system) is displayed. 21. Click Next.
Figure 10: Service Account Note: Do not select the Customize for each service account information checkbox. 23. Enter the group names to run different services in the Domain Groups for Clustered Services window. Note: You must complete the remaining steps to enter the group names for services. Follow the steps and create one group in the domain and use the same group for all the services. 24. Under the Administrators group, create one group named sqlaccts in the domain. 25.
Figure 11: Domain groups for clustered services 26. Click Next. The Authentication mode page appears. 27. Select Windows authentication mode. 28. Click Next. The Collation settings window appears. 29. By default Dictionary order, case-sensitive, for use with 1252 Character set is selected. If not, be sure to select the options.
Figure 12: Collation settings 30. Click Next in the Error and send Report Settings window. The Ready to Install window appears. 31. Verify that all selected components are displayed and then click Install. The Set Progress window appears where you can monitor the installation progress of each component on any of the nodes in the cluster by selecting the node from the dropdown list. After setup is complete, all of the components should have a green check beside them and show a status of Set Up Finished.
IMPORTANT: Before you begin, be sure you have all system and pre-installation requirements fulfilled. In addition, the Microsoft SQL Server 2005 service should be running. To be sure that you meet these requirements, see the HP Systems Insight Manager 5.x Installation and Configuration guides on the HP Management CD. 1. Ensure that both systems are up and running cluster services before installation. Also, be sure that the SQL server instance, to which you are installing the HP SIM 5.
9. Click the HP SIM 5.x- Windows Install link. The HP Systems Insight Manager Set up window appears. 10. Click Install. The Welcome to the HP Systems Insight Manager Installer window appears. 11. After completing the system inspection, the Database Configuration window appears. a. The Username field displays the user name that is logged in. b. Enter the password in the Password field. c. The Domain field displays the user domain used to log into the system. d.
vi. Click Finish to close the Setup – OpenSSH Services for HP Systems Insight Manager wizard window. b. A new Welcome to the Pegasus WMI Mapper V2.4 Setup Wizard window appears. i. Click Next. The End-User License Agreement window appears. ii. Select I accept the terms in the License Agreement. iii. Click Next. The Choose Setup Type window appears. iv. Select Typical. The Ready to Install window appears. v. Click Install to continue to the Installing Pegasus WMI Mapper v2.4 window.
Figure 13: Remote Support Software Manager initialization e. A new HP Package Setup: Version Control Repository Manager window appears. Note: If the Version Control Repository Manager is already installed on your system, this window is not displayed. Note: If you do not want to install the Version Control Repository Manager, click Close to skip this component. You can move on to step 13f. i. Click Install to proceed to the Repository Directory window.
ix. Click Close. 22. Click Next from the Custom Install – Status window on the HP Systems Insight Manager Installer window to close the window. 23. Click REGISTER LATER from the Registration window. 24. Select Yes, reboot system now in the Installation complete window, and then click Finish. 25. Click OK. 26. Shutdown the system. Installing HP SIM 5.
Figure 14: Server DSN Configuration 8. Select the database, which is created by the secondary system. Use the database name indicated in the Error! Reference source not found. section. 9. Click Next. 10. Click Finish to complete the configuration. A Summary window appears. 11. Click OK. The ODBC Data Source Administrator window appears. 12. Click OK to close the ODBC Data Source Administrator window appears. Adding the HP SIM 5.x cluster resources To complete the installation of HP SIM 5.
Figure 15: Failover Cluster Management 4. Under the High Availability Wizard Page, the Before you begin page appears. Click Next. 5. The Select Service or Application Page appears. Choose Generic Service from the drop-down menu and click Next.
Figure 16: Generic Service 6. The Select Service page appears. Select the HP System Insight Manager from the given services and click Next.
Figure 17: Select the service you want to use from the list 7. The Client Access Protocol window appears. Give the name of the HP SIM service as HPSIM_2008 in this case and IP address of the HP SIM Service of the cluster and click Next.
Figure 18: Client Access Point 8. The Select Storage window appears. Select the storage on which HP SIM is installed and click Next.
Figure 19: Select Storage 9. The Confirmation Page appears. It lists all the details you have chosen in the previous windows. Click Next.
Figure 20: Confirmation window 10. The Configure High Availability window appears. It shows the progress bar for configuring the service then the Summary Page appears.
Figure 21: Configure High Availability 11. Click Finish. The HP SIM service is shown under Services and Applications.
Figure 22: Services and Applications Summary Creating the OpenSSH Services for HP SIM 5.x Generic Service Resource 1. Right click on HP SIM Service under Services and Application. Click Add a resource Generic service in the left pane of the Failover Cluster Management window.
Figure 23: Generic Service 2. The Select Service Page appears. Select Open SSH Service from the list and click Next.
Figure 24: Select the service you want to use from the list 3. The Confirmation Page appears and displays the default service name as Open SSHd service and parameters. Click Next.
Figure 25: You are ready to make a Generic Service 4. The Summary Page appears. Click Finish. Open SSH service is shown under hpsim_sql2005.
Figure 26: The new resource was successfully created and configured Creating the Pegasus WMI Mapper Services for HP SIM 5.x Generic Service Resource 1. Right click on HP SIM Service under Services and Application. Click Add a resource Generic service in the left pane of the Failover Cluster Management window.
Figure 27: Generic Service 2. The Select Service Page appears. Select Pegasus WMIMapper from the list and click Next.
Figure 28: Select Service 3. The Confirmation Page appears. It displays the default service name as Pegasus WMIMapper (WMIMapper) service and parameters. Click Next.
Figure 29: Confirmation 4. The Summary Page appears. Click Finish. Pegasus WMIMapper service is shown under hpsim_sql2005.
Figure 30: Summary Creating the Version Control Repository Manager (VCRM) 5.x for HP SIM 5.x Generic Service Resource A VCRM generic service resource must be created if you opted to install the VCRM in step 8 of the Installing HP SIM 5.x on the primary system section. 1. Right click on HP SIM Service under Services and Application. Click Add a resource Generic service in the left pane of the Failover Cluster Management window.
Figure 31: Generic Service 2. The Select Service Page appears. Select HP Version Control Repository Manager service from the list and click Next.
Figure 32: Select Service 3. The Confirmation Page appears. It displays the default service name as HP Version Control Repository Manager (cpqsrhmo) service and parameters. Click Next.
Figure 33: Summary 4. The Summary Page appears. Click Finish. Hp Version Control Repository Manager service is shown under hpsim_sql2005.
Figure 34: Service 5. Right click on HP Version Control Repository Manager service and click the Properties link.
Figure 35: Summary of hpsim_sql2005 6. The HP Version Control Repository Manager Properties Page displays. 7. Click the dependencies tab and insert the dependency as the disk which was chosen for HP SIM installation. Click Apply and then click OK.
Figure 36: HP Version Control Repository Manager Properties Bringing the virtual group containing the HP SIM 5.x resources online 1. Right click on the HPSIM Service under Services and Applications in the left pane and select the Bring this service and application online from the dropdown menu. If configured properly, all resources will come online.
Figure 37: Bring this service or application online 2. All services (HP System Insight Manager, Open SSH Server, Pegasus WMI Mapper (WMI Mapper), HP Version Control Repository Manager) will come online automatically.
Figure 38: Summary of hpsim_sql2005 3. The installation of HP SIM 5.x is complete. Validating the installation To be sure that the HP SIM 5.x service can be moved between both systems, perform the fol lowing steps from either one of the cluster systems: 1. Open the Cluster Administrator and connect to the cluster. 2. In the Cluster Administrator window, on the left pane, right-click on the disk group containing the HP SIM 5.x program files. For example, HP SIM Disk Group is used in this paper.
Note: The HP SIM 5.x icon on the Windows desktop of each system was created by the installation of HP SIM 5.x as a handy shortcut for a regular standalone server only. This icon is no longer applicable at this point because the HP SIM 5.x is clustered. The icon should be deleted from the desktop of each system to avoid future confusion. 5. A security alert displays. Click OK. The Login window appears. 6. Be sure to log in with the appropriate username, password, and domain for your cluster.
Figure 40: HP SIM 5.x home page Note: Navigate to OptionsDiscovery. Select System Automatic Discovery task and click Edit. The Edit Discovery page appears. Take a look at the Ping inclusion ranges list box (on the left side of the right frame, near the bottom of the screen). Note that HP SIM 5.x automatically generates a range for each of the IP addresses the current system has. Because one of these ranges is based on the cluster heartbeat IP address (generally of the form 10.0.0.
Troubleshooting Note: This section is applicable only if PMP has been installed manually. Problem: Error during MSA tool execution. Solution: Execution of MSA tools might fail due to SSH key mismatch. For proper execution of MSA tools, perform the following: 11. Make the primary system active and execute mxagentconfig to push the SSH key to primary system itself. AND 12. Make secondary system active and execute mxagentconfig to push the SSH key to secondary system itself.
For more information Refer to the following for more information regarding the topics referenced in this paper. Microsoft cluster services Clustering basics www.microsoft.com/windows2000/technologies/clustering/default.asp Steps to setting up a Microsoft cluster www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp HP ProLiant clusters http://h18000.www1.hp.com/solutions/enterprise/highavailability/microsoft/index.