3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Configuration and Operation

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