I'm currently installing VC 2.5, or at least trying to do.
Environment: SQL 2005 SP2, Windows 2003 in a Domain (Lab Domain), all 32 bit. SQL on the same server ans VC Install should go to.
No mater what I do, the install process always moans about having not enough permissions.
I tried:
1.
Created a DB and assigned a local SQL User as the owner to it, furthermore I've given this user db_owner rights on the msdb DB
2. Used a newly created Domain User, assigned it as the owner of the DB Files, also given db_owner rights on msdb.
No matter what I do, it doesn't work. I also tried to assign this user as the owner of msdb which hasn't helped at all.
There is not that much information in the docs and I followed it including what's in the KB. As there is not that much information, I assume it should be straight forward, but not for me
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 product setup directory in source media <C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\..\vpx\VMware-VIClient.exe>
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Found "C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\..\vpx\VMware-VIClient.exe"
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 setup found on the media
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 product setup directory in source media <C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\..\vpx\VMware-VCServer.exe>
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Found "C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\..\vpx\VMware-VCServer.exe"
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 setup found on the media
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 product setup directory in source media <C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\..\vci\VMware-UpdateManager.exe>
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Found "C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\..\vci\VMware-UpdateManager.exe"
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 setup found on the media
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 db name is : 0 raiserror('User does not have sysadmin or db_owner privileges on the msdb database.',16,1);
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 SQLRETURN value is: 0
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 sql query: use "dbvc";
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Failed to execute query: -1
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Attempting to retrieve error message for error Id: 25110
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Msi Error table Query is
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Error message is The DB user entered does not have the required permissions needed to install and configure VMware VirtualCenter Server with the selected DB. Please see the installation documentation for detailed DB permission requirements.
In your image, it shows your dbvc user in the sysadmin server role, this user should NOT be a sysadmin.
Also, if any previous attempts to install the software have added stats rollup jobs to the SQL agent, those will need to be removed before attempting to install (although I am not sure you have gotten that far).
