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

• If you want to use replication on a SQL instance assigned to a Virtual SQL Server, you will need
to define the replication after you add the instance to the Virtual SQL Server.
• If you assign multiple SQL instances to the same Virtual SQL Server, keep in mind that a failure of
one instance can cause the Virtual SQL Server to fail over. This failover will include all instances
associated with the Virtual SQL Server, not just the failed instance.
• A Virtual SQL Server can include both SQL Server 2005 and 2008 instances.
• An instance of SQL Server cannot be virtualized if the physical computer name is changed after
the SQL instance is installed and before the instance is virtualized.
To add a SQL instance to a Virtual SQL Server, select the Virtual SQL Server on the PolyServe
Management Console, right-click, and select Add Virtual SQL Instance.
Name: This field lists all of the SQL instances that are available for assignment to this Virtual SQL
Server. Select the appropriate SQL instance.
NOTE:
HP PolyServe Software uses the following rules to determine the SQL instances that can be assigned
to the Virtual SQL Server. The Name field does not include instances that do not meet these
requirements.
• The SQL instance must exist on all of the nodes providing network interfaces for the Virtual SQL
Server. (The instance must have the same name on all of the nodes.)
• The SQL instance cannot be in use on any of the nodes as a primary for another Virtual SQL
Server.
• The SQL instance on the primary node cannot currently be a backup for another Virtual SQL
Server.
Port: Enter the port number for TCP/IP Sockets that the SQL Server instance should listen on. Specifying
a port is required.
Virtual data root: Specify the full path that will be used for the data files and directories for this virtual
SQL Server instance. This location will store the SQL Data Root that was created when the SQL Server
instance was installed. (In mx commands, the virtual data root is referred to as the vpath.)
HP PolyServe Software for Microsoft SQL Server administration guide 61