5.0

Microsoft SQL Server Configuration
A Microsoft SQL Server configuration must meet specific requirements to support VRM. You must configure
these requirements in Microsoft SQL Server.
n
You can use either a named instance or the default instance of SQL Server.
n
Enable TCP on the database instance.
n
Use a static TCP port, for example set to the default of 1433. Alternatively, to use dynamic TCP ports, you
must perform additional configuration.
n
Use a named instance of SQL Server rather than the default instance. You can only use dynamic ports
with a named instance of SQL Server.
n
In the DB URL in the VRMS configuration interface, replace port= port_number with
instanceName= instance_name .
n
Verify that the SQL Server Browser service is running.
n
The SQL Server Browser runs on port 1434. Use the PortQuery tool from a remote machine to check
that the port on which the SQL Server Browser service runs is not blocked by a firewall.
PortQry.exe -n
Machine_Name -p UDP -e 1434
n
Because the VRMS and the database server run on different hosts, you must use mixed mode
authentication and not Windows Authentication.
n
The VRM database requires a security login with SQL Server Authentication.
n
The VRM database login must be the database owner.
n
Because it is the database owner, the login maps to the database user dbo and uses the dbo schema. Keep
the dbo user and dbo schema settings.
n
The VRM database user must have database administrator privileges.
n
The VRM database user must have the following permissions:
n
bulk insert
n
connect
n
create table
n
create view
Oracle Server Configuration
An Oracle Server configuration must meet specific requirements to support VRM. Oracle Server has the
following configuration requirements when used as the VRM database.
n
When creating the database instance, specify utf-8 encoding.
n
The VRM database user (the database user name you supply when configuring the SRM database
connection) must be granted the following permissions:
n
connect
n
resource
n
create session
n
create view
Site Recovery Manager Administration Guide
30 VMware, Inc.