5.5

Table Of Contents
Configure Microsoft SQL Server for vSphere Replication
When you create a Microsoft SQL Server database, you must configure it correctly to support
vSphere Replication.
You use SQL Server Management Studio to create and configure an SQL Server database for
vSphere Replication.
This information provides the general steps that you must perform to configure an SQL Server database for
vSphere Replication. For instructions about how to perform the relevant steps, see the SQL Server
documentation.
Prerequisites
Verify that the SQL Server Browser service is running.
Procedure
1 Select Mixed Mode Authentication when you create the database instance.
The vSphere Replication appliance and the database server run on different hosts, so you must use
mixed mode authentication and not Windows Authentication.
2 Use either a named instance or the default instance of SQL Server.
If you intend to use dynamic TCP ports, you must use a named instance of SQL Server.
3 Enable TCP on the database instance.
4 Set a TCP port.
Option Action
Static TCP port
Set the TCP port to the default of 1433.
Dynamic TCP port
a Use a named instance of SQL Server. You can only use dynamic ports
with a named instance of SQL Server.
b Select the Show DB URL check box in the virtual appliance
management interface (VAMI) of the vSphere Replication appliance.
c Modify the DB URL value. Replace port=port_number with
instanceName=instance_name in the URL.
d
Use the PortQuery command from a remote machine to check that the
port on which the SQL Server Browser service runs is not blocked by a
firewall. The SQL Server Browser runs on port 1434. Type the
PortQuery command in a terminal window.
PortQry.exe -n Machine_Name -p UDP -e 1434
5 Verify that the firewall on the database server permits inbound connections on the TCP port.
6 Create the vSphere Replication security login.
7 Create the vSphere Replication database and set the vSphere Replication security login as the database
owner.
8 Keep the dbo user and dbo schema settings.
Because the vSphere Replication security login is the database owner, it maps to the database user dbo
and uses the dbo schema.
Configure Oracle Server for vSphere Replication
You must configure an Oracle Server database correctly to support vSphere Replication.
You create and configure an Oracle Server database for vSphere Replication by using the tools that Oracle
Server provides.
Chapter 8 Installing vSphere Replication
VMware, Inc. 65