vCenter

 View Only

  • 1.  Chargeback add vcenter SQL error

    Posted May 21, 2014 05:08 PM

    Hi,

    I'm trying to add a vCenter server to ChargeBack.

    I get the following error message :

    Invalid vCenter Server database. The vCenter Server database must have the following views: VPXV_HIST_STAT_DAILY, VPXV_HIST_STAT_WEEKLY, VPXV_HIST_STAT_MONTHLY and VPXV_HIST_STAT_YEARLY

    On this post, (https://communities.vmware.com/thread/236730) people say that the sql account must be db_owner on the vCenter database, I do that and say that we must create the views.

    In SQL management Studio, i can see these views, but exactly. I have the same names but like that : VMW.VPXV_HIST_STAT_DAILY, VMW.VPXV_HIST_STAT_WEEKLY.....

    Is it normal ?

    Best regards



  • 2.  RE: Chargeback add vcenter SQL error
    Best Answer

    Posted May 27, 2014 02:42 PM

    Hi,

    i solved my problem.

    In fact, i changed the schema (in sql)  for the vCCM sql user from dbo to MVW and i can add a vcenter.