4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 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 4.1 administration guide 73