Cluster Server 8.0 Implementation Guide for Microsoft SQL Server - Windows
- Section I. Introducing Veritas InfoScale solutions for application high availability
- Understanding the InfoScale solutions for application high availability
- About the VCS agents for SQL Server
- How VCS monitors storage components
- How application availability is achieved in a physical environment
- How is application availability achieved in a VMware virtual environment
- Managing storage and installing the VCS agents
- Installing SQL Server
- Understanding the InfoScale solutions for application high availability
- Section II. Configuring SQL Server in a physical environment
- Overview
- Configuring the VCS cluster
- Configuring the SQL Server service group
- Configuring a SQL Server service group using the wizard
- Making SQL Server user-defined databases highly available
- Verifying the service group configuration
- Administering a SQL Server service group
- Configuring an MSDTC service group
- Configuring the standalone SQL Server
- Configuring an Active/Active cluster
- Configuring a disaster recovery setup
- Section III. Configuring SQL Server in a VMware environment
- Configuring application monitoring using the Veritas High Availability solution
- Administering application monitoring
- Administering application monitoring using the Veritas High Availability tab
- Administering application availability using Veritas High Availability dashboard
- Understanding the dashboard work area
- Section IV. Appendixes
- Appendix A. Troubleshooting
- Error and warning messages from VCS agent for SQL Server
- Troubleshooting application monitoring configuration issues
- Troubleshooting Veritas High Availability view issues
- Appendix B. Using the virtual MMC viewer
- Appendix A. Troubleshooting
Configuring the VCS cluster
VCS cluster configuration involves selecting the virtual machines on which you want to configure monitoring and setting up the network communication links between the selected virtual machines.
To configure the VCS cluster
- Launch the vSphere Client and connect to the vCenter Server that manages the virtual machine. On the Inventory view of the vCenter Server, in the left pane, select the virtual machine where you want to configure application monitoring. Then, in the right pane, select the Veritas High Availability tab.
- On the Veritas High Availability view, click Configure a VCS Cluster. This launches the VCS cluster configuration wizard. Unless you configure a cluster, you cannot configure an application for monitoring.
- On the Welcome panel, review the pre-requisites and then click Next.
- On the Configuration Inputs panel, specify the systems for the VCS cluster operations and the user account details for each system.
Note:
The specified user account must have administrative privileges on the system.
The Cluster systems lists the systems that are included in the cluster configuration. The local system is selected by default.
To add more systems, click Add System and then on the Add System dialog box, specify the following details of the system that you want to add to the VCS cluster.
System Name or IP address
Specify the name or IP address of the system that you want to add to the VCS cluster.
User name
Specify the user account for the system. The user name must be in the domain.com\username.
Note:
The specified user must be a domain user having administrative privileges on all the selected system.
Password
Specify the password for the user account mentioned.
Use the specified user account on all systems
Uses the specified user account on all the cluster systems. This option is selected by default.
The wizard validates the system details and then adds the system to VCS cluster system list.
- Skip this step if you do not want to modify the default security settings for your cluster.
To modify the security settings for the cluster, on the Configuration Inputs panel, click Advanced Settings . In the Advanced settings dialog box, specify the following details and then click OK.
Use Single Sign-on
Select to configure single sign-on using VCS Authentication Service for cluster communication.
This option is enabled by default.
Use VCS user privileges
Select to configure a user with administrative privileges to the cluster.
Specify the user name and password and click OK.
- On the Network Details panel, select the type of communication for the VCS cluster and then select the adapters to configure the communication links.
Depending on the network over which you want to configure the links, select:
Use MAC address for cluster communication (LLT over Ethernet) : The LLT over ethernet communication configures the links over the non-routed network. Choose this mode only if the failover target systems reside in the same subnet.
Use IP address for cluster communication (LLT over UDP): The LLT over UDP communication configures the links over the routed network. You choose this mode regardless of whether the failover target systems reside in the same subnet or in different subnets. You can select only those adapters that have an IP address.
You must select a minimum of two adapters per system.
Veritas recommends the following:
IP addresses that are assigned to the selected adapters should be in different subnets.
One of the network adapters must be a public adapter. You may assign low priority to the VCS cluster communication link that uses the public adapter.
Network Adapter
Select a network adapter for the communication links.
You must select a different network adapter for each communication link.
To configure links over UDP, select the IP version and then specify the required details for each communication link.
Note:
Do not select the teamed network adapters and the independently listed adapters that are a part of the teamed NIC.
IP Address
Specify the IP address for cluster communication over the specified UDP port.
Port
Specify a unique port number for each link. You can use ports in the range 49152 to 65535.
A specified port for a link is used for all the cluster systems on that link.
Subnet mask
Displays the subnet masks to which the specified IP belongs.
By default, the VCS cluster communication link that uses the public adapter is configured as low-priority link. To change the priority, click Modify. In the Modify low-priority link dialog box, select the link and click OK.
For information about adding or changing the selected network links after the configuration workflow is complete, see the Cluster Server Administrator's Guide.
- On the Configuration Summary panel, specify a cluster name and a cluster ID of your choice. Review the VCS cluster configuration details and then click Next to initiate the configuration.
If the network contains multiple clusters, the wizard verifies the cluster ID with the IDs assigned to all the accessible clusters in the network. The wizard does not validate the assigned ID with the clusters that are not accessible during the validation. Veritas recommends you to validate the uniqueness of the assigned ID in the existing network.
- On the Implementation panel, the wizard displays the VCS cluster configuration tasks and the status of each task. After all the tasks are complete, click Next.
If the configuration tasks fail, click Diagnostic information to check the details of the failure.
Rectify the cause of the failure and run the wizard again to configure the VCS cluster.
- On the Finish panel, click Finish to complete the wizard workflow. This step completes the VCS cluster configuration.
The Veritas High Availability view now displays the link to configure an application for high availability.