EddieH3
Contributor
Contributor

Installation Error-Failed to create database tables

Jump to solution

During the installation of SRM, I receive the following error:

Failed to create database tables. Details: DB does not contain SRM schema: VdbError: Column name does not exist in table dr_product_info

The SRM documentation states the schema name must be the same as the DB user name which I have verified. Does anyone have a fix for this error?

0 Kudos
1 Solution

Accepted Solutions
CHogan
VMware Employee
VMware Employee

This is the error you get when the user who is connecting to the DB is not the

owner of the DB. Because of this, the

user does not have the privileges to view some columns in the table.

If you change the owner of the DB to the user that you are using to connect to the DB, then you should be able to complete the installation.

HTH

Cormac

http://cormachogan.com

View solution in original post

0 Kudos
8 Replies
CHogan
VMware Employee
VMware Employee

This is the error you get when the user who is connecting to the DB is not the

owner of the DB. Because of this, the

user does not have the privileges to view some columns in the table.

If you change the owner of the DB to the user that you are using to connect to the DB, then you should be able to complete the installation.

HTH

Cormac

http://cormachogan.com

View solution in original post

0 Kudos
GavinPeng
Contributor
Contributor

I have the same problem,I have modified that the SRM database 's permission is db_owner.can you share your practice?TKS

0 Kudos
GavinPeng
Contributor
Contributor

Today,I try to modify the SRM database for SQL SERVER 2005,securityloginserver roles--set the following permission:

bulk insert,connect,create table,create view.

reference to 'Site Recovery Manager Administration Guide'.resolve the problem.

0 Kudos
tdubb123
Expert
Expert

now I get the message

Failed to install certificate.

Details: A database error occur has occured.

Press retry or cancel.

any idea?

0 Kudos
tdubb123
Expert
Expert

i am seeing this in the srm logs

Section for VMware vCenter Site Recovery Manager, pid=2768, version=4.0.0, build=build-192921, option=Release

Failed to create console writer

Set dump dir to 'C:\Documents and Settings\All Users\Application Data\VMware\VMware vCenter Site Recovery Manager\DumpFiles'

Intializing the DBManager

Connection: Could not connect to database: -1

DBManager error: Could not initialize Vdb connection: ODBC error: (28000) - [SQL Native Client][SQL Server]Login failed for user 'domain\SRM$'.

Application initialization error: Could not initialize Vdb connection: ODBC error: (28000) - [SQL Native Client][SQL Server]Login failed for user 'domain\SRM$'.

vmware-dr service stopped

0 Kudos
Michelle_Laveri
Virtuoso
Virtuoso

Are you using Windows Authentication on a remote SQL server - if you are - are you aware its not supported?

Windows authentication is only supported if the SQL instances is local to the SRM...

Putting that aside you should not need DB_OWNER on the SRM tables...

These instructions show how to set the right DB privileges on SQL Express and worked with SQL 2005...

http://communities.vmware.com/docs/DOC-11547

My new book on SRM 4.0 more or less reloads the doc above but for the SQL 2005 UI...

Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/

Free PDF or at-cost Hard Copy

Regards Michelle Laverick @m_laverick http://www.michellelaverick.com
0 Kudos
tdubb123
Expert
Expert

Thanks Mike.

This doc solved my problem

http://communities.vmware.com/docs/DOC-11547

0 Kudos
Michelle_Laveri
Virtuoso
Virtuoso

Ah good - I wish this was included in the core admin PDF for VMware - and not just for MS SQL, but for other DB vendors such as Oracle and IBM DB2......

Anyway, problem solved... 😄

Regards

Mike Laverick

RTFM Education

http://www.rtfm-ed.co.uk

Author of the SRM Book:http://www.rtfm-ed.co.uk/2010/03/22/new-administrating-vmware-site-recovery-manager-4-0/

Free PDF or at-cost Hard Copy

Regards Michelle Laverick @m_laverick http://www.michellelaverick.com
0 Kudos