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?
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
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
I have the same problem,I have modified that the SRM database 's permission is db_owner.can you share your practice?TKS
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.
now I get the message
Failed to install certificate.
Details: A database error occur has occured.
Press retry or cancel.
any idea?
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'
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$'.
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
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
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
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