1.0

Table Of Contents

Site Recovery Manager Administration Guide

22 VMware, Inc.

Table 2‐1liststhedatabasesthatSRMsupports.

Microsoft SQL Server Configuration

MicrosoftSQLServerhasthefollowingconfigurationrequirementswhenusedwith

SRM:

 Theschemanamemustbethesameastheusername.Youmusthaveadefault

schemaassociatedwithyouruseraccount.

 Youmusthavebulkinsertadministratorprivileges.

 IfyouareusingWindowsauthentication,theSRMserveranddatabaseserver

mustrunonthesamehost.

 IfSQLServerisinstalledlocally,youmightneedtodisabletheSharedMemory

networksettingonthedatabaseserver.

 TheSRMdatabaseusermustbegrantedthefollowingpermissions:connect,create

table,createview.

Table 2-1. SRM Supported Databases

Database Type Service Pack, Patch, and Driver Requirements

MicrosoftSQLServer2005Enterprise

(64‐bitversionwithSP2isalsosupported)

SP1orSP2

ForWindows2000andWindowsXP,apply

MDAC2.8SP1totheclient.

UseSQLnativeclientdriverfortheclient.

MicrosoftSQLServer2005Standard UseSQLnativeclientdriverfortheclient.

MicrosoftSQLServer2005

Express UseSQLnativeclientdriverfortheclient.

MicrosoftSQLServer2000Enterprise SP4

MicrosoftSQLServer2000Standard SP4

Oracle9irelease2Standard

Oracle9irelease2Enterprise

Applypatch9.2.0.8.0totheserverandclient.

Driverversion10.02.x.x

Oracle10gEnterpriseRelease1Driverversion10.02.x.x

Oracle10gEnterpriseRelease2

(64‐bitversion

isalsosupported)

Firstapplypatch10.2.0.3.0totheclientandserver.

Thenapplypatch5699495totheclient.

Driverversion10.02.x.x