SRM Upgrade Failing wiht "Failed to create database tables."

[esnmb]

I have tried the service account, the SA account and my own domain admin account but I am getting this error still.

The service account and my account are SQL admin accounts....

Any ideas?

[ImranMogal]

Check ODBC test result for connection

[esnmb]

It tests successful.

[esnmb]

This is from the vmware-dr-xxx.log file:

Section for VMware vCenter Site Recovery Manager, pid=2172, version=5.0.0, build=build-474459, option=Release

2012-03-07T08:55:52.207-05:00 [02176 info 'Default'] Initialized channel manager

2012-03-07T08:55:52.207-05:00 [02176 info 'Default'] Current working directory: C:\Program Files (x86)\VMware\VMware vCenter Site Recovery Manager\bin

2012-03-07T08:55:52.208-05:00 [02176 verbose 'ThreadPool'] TaskMax=200, IoMin=1, IoMax=401

2012-03-07T08:55:52.209-05:00 [02176 verbose 'ThreadPool'] Setting COM threading model to MTA

2012-03-07T08:55:52.321-05:00 [02176 warning 'Vdb'] Execute - SQL execution failed: SELECT * FROM VPX_VERSION

2012-03-07T08:55:52.321-05:00 [02176 warning 'Vdb'] Execute -    Bind parameters:

2012-03-07T08:55:52.321-05:00 [02176 warning 'Vdb'] Execute - ODBC Error: "ODBC error: (42S02) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'VPX_VERSION'." is returned when executing SQL statement "SELECT * FROM VPX_VERSION"

2012-03-07T08:55:52.334-05:00 [02176 warning 'Vdb'] Backtrace:

--> backtrace[00] rip 00f4a9ed (no symbol)

--> backtrace[01] rip 00e9aa84 (no symbol)

--> backtrace[02] rip 00e9aff7 (no symbol)

--> backtrace[03] rip 00263962 (no symbol)

--> backtrace[04] rip 00263b04 (no symbol)

--> backtrace[05] rip 00405edc (no symbol)

--> backtrace[06] rip 0040752f (no symbol)

--> backtrace[07] rip 00428b64 (no symbol)

--> backtrace[08] rip 7586339a (no symbol)

--> backtrace[09] rip 76fb9ed2 (no symbol)

--> backtrace[10] rip 76fb9ea5 (no symbol)

-->

2012-03-07T08:55:52.334-05:00 [02176 error 'Vdb'] VdbStatement::Execute(): Failed: "ODBC error: (42S02) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'VPX_VERSION'." is returned when executing SQL statement "SELECT * FROM VPX_VERSION"

[mal_michael]

Hi,

Try "Run as Administrator" when running the installer.

The DB user must be the owner of SRM database.

Michael.

[gianstif]

Hello,

We are issuing the same problems. Is this error solved and/or is there an update status?

gr.

[TCLiven]

maybe this will help.. We had this same issue and realized we were not following these instructions to a 't'

http://virtualistmanifesto.com/2011/10/11/vcenter-site-recovery-manager-5-0-and-sql-server-configura...

[esnmb]

Tried to do this today as well, but no go.

[mal_michael]

You must use 32-bit DSN for SRM.

Run c:\windowssyswow64\odbcad32.exe and make sure you DSN is listed under system dsn.