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

5 Configure Virtual SQL Servers
This chapter describes how to perform the following tasks:
• Configure Virtual SQL Servers.
• Assign SQL instances to Virtual SQL Servers.
• Configure SQL clients.
• Change the primary node for a Virtual SQL Server.
• Perform operational tasks such as enabling or disabling a SQL service monitor.
• Stop SQL Server and Matrix Server.
• Perform database backups.
• Configure SQL mail and SQL Agent mail.
• Uninstall SQL Server instances.
Configure Virtual SQL Servers
You will need to create Virtual SQL Servers for the SQL instances that you have installed. A Virtual
SQL Server includes network interfaces located on a primary node and one or more backup nodes.
The SQL instances to be added to the Virtual SQL Server must exist on each of these nodes
DNS requirement for Virtual SQL Servers
A DNS entry must exist for each Virtual SQL Server/IP address. The entry must include an A record
and a PTR record for forward and reverse lookup. Windows authentication may fail if these records
do not exist. Be sure to create a DNS entry for each Virtual SQL Server/IP address that you create.
Create a Virtual SQL Server
To create a Virtual SQL Server, start the PolyServe Management Console and then select Matrix >
Add > Add Virtual SQL Server. The Add Virtual SQL Server window appears.
HP PolyServe Software for Microsoft SQL Server administration guide 57