4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

Virtual IP: Specify the IP address that will be associated with this Virtual SQL Server.
Name: Enter the NetBIOS name for this Virtual SQL Server; the name can include up to 15 characters.
Application name: An “application” provides a tag to group Virtual SQL Servers and related virtual
SQL instances on the Applications tab. All of the resources associated with the application can then
be treated as a unit on the Applications tab. You can specify a new application name, select an
existing application name, or leave this field blank. However, if you do not assign a name, Matrix
Server will use the IP address for the Virtual SQL Server as the application name.
Manage MSDTC: Microsoft Distributed Transaction Coordinator (MS DTC) is used to coordinate
transactions between different SQL instances running on different nodes in the cluster. There is one
MSDTC service on each machine.
NOTE:
HP PolyServe Software provides two methods to virtualize MS DTC, thus enabling transactions that
span one or more Virtual SQL Servers. MS DTC can be configured for high availability, as described
in Chapter 6 on page 77, or it can be managed by a specific Virtual SQL Server. If you will be
configuring MS DTC for high availability, do not check Manage MSDTC on the Add Virtual SQL
Server dialog.
To manage MS DTC via this Virtual SQL Server, HP PolyServe Software and the nodes must be
configured as follows:
• The “Manage MSDTC” box is checked on the Add Virtual SQL Server dialog.
• On the nodes configured for the Virtual SQL Server, the Default Coordinator for MSDTC is set to
“Use local coordinator.” This is done on the MSDTC tab of the My Computer Properties dialog
(see Appendix B on page 145). If a Remote Host is specified as the Default Coordinator, HP Poly-
Serve Software cannot virtualize MSDTC. (Note that if MSDTC is virtualized and the Default Co-
ordinator is then set to a Remote Host, the MSDTC will no longer be managed by the Virtual SQL
Server.)
The following limitations exist when using a Virtual SQL Server to manage MSDTC.
• Because only one MSDTC resource exists per machine, you can define MSDTC support for only
one Virtual SQL Server per machine. You can, however, define other Virtual SQL Servers that do
not support MSDTC.
Configure Virtual SQL Servers58