Hi there
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
Anyone any Idea?
Thanks
Andre
I'm running the 32 bit Version of the OS and SQL Server.
Install Log attached. I've seen that it moans about missing rights on the msdb, which is nonsens, as you can see in the attached picture
VMINST.LOG:
-cut-
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Begin Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 ======================================================================
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 --- CA exec: VMResetRegSecurity
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Reseting security for HKLM\SOFTWARE\VMware, Inc.
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Reseting security for HKLM\SOFTWARE\VMware, Inc.\VMware VirtualCenter
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 End Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Begin Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 --- CA exec: VMCheckPendingReboots
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Checking for pending reboots...
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 checking for pending reboots under Microsoft\Updates key...
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 checking for pending reboots under <SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\RebootRequired> ...
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 registry entry with data 1 not found
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 End Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Begin Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 --- CA exec: VMCheckOSRequirements
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property VersionNT64 =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 End Logging
VMware Update Manager-build-84689: 06/24/08 17:29:11 Begin Logging
VMware Update Manager-build-84689: 06/24/08 17:29:11 --- CA exec: VMDetectProxySettings
VMware Update Manager-build-84689: 06/24/08 17:29:11 Default Browser is IExplore
VMware Update Manager-build-84689: 06/24/08 17:29:11 Proxy is not enabled on this system
VMware Update Manager-build-84689: 06/24/08 17:29:11 Setting property USE_PROXY =
VMware Update Manager-build-84689: 06/24/08 17:29:11 Setting property PROXY_SERVER =
VMware Update Manager-build-84689: 06/24/08 17:29:11 Setting property PROXY_PORT =
VMware Update Manager-build-84689: 06/24/08 17:29:11 End Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Begin Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Saving installer window caption
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property ProductName = VMware Infrastructure Management
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 End Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Begin Logging
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 --- CA exec: VMSetVIMGuiProperties
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property OLD_VICLIENT_VERSION =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 property is empty. product is not already installed on the system
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property InstallOrUpgrade_VIClient = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property SourceDir = C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\
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 Setting property MediaExists_VIClient = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SourceDir_VIClient = 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 Getting Property UnSupportedOS_VIClient =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property MediaExists_VIClient = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property InstallOrUpgrade_VIClient = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VICLIENT_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VICLIENT = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VICLIENT_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VICLIENT = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VICLIENT_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VICLIENT = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property OLD_VCSERVER_VERSION =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 property is empty. product is not already installed on the system
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property InstallOrUpgrade_VCServer = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property SourceDir = C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\
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 Setting property MediaExists_VCServer = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SourceDir_VCServer = 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 Getting Property UnSupportedOS_VCServer =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property MediaExists_VCServer = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property InstallOrUpgrade_VCServer = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VCSERVER_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VCSERVER = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VCSERVER_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VCSERVER = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VCSERVER_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VCSERVER = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property OLD_VCI_VERSION =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 property is empty. product is not already installed on the system
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property InstallOrUpgrade_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property SourceDir = C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\
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:11 Setting property MediaExists_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SourceDir_VCI = 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 Getting Property UnSupportedOS_VCI =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property MediaExists_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property InstallOrUpgrade_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VCI_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VCI_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property SHOW_VCI_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property INSTALL_VCI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property OLD_CONVERTER_VERSION =
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 property is empty. product is not already installed on the system
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Setting property InstallOrUpgrade_Converter = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 Getting Property SourceDir = C:\Documents and Settings\Administrator.ZYCKOTSC\Desktop\VMware-VIMSetup-2.5.0-84782\vi\
VMware VirtualCenter-build-84782: 06/24/08 17:29:11 product setup directory in source media
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 SQL Server is not a desktop edition.
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 SQLFetch: DB Name = dbvc
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 The DSN is NOT pointing to the master database.
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Query :SELECT * FROM dbvc.VPX_VERSION;
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 ODBC Error: [SQL Native Client][SQL Server]Invalid object name 'VPX_VERSION'.
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Setting property SHOW_EVAL_UI = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Setting property EVAL = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 The database is empty. Setup will create a new database repository.
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 sql query: select DB_NAME();
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 ODBC Error: [SQL Native Client][SQL Server]Incorrect syntax near 'dbvc'.
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Getting Property UILevel = 5
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.
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Successfully retrieved error message from Error table
VMware VirtualCenter-build-84782: 06/24/08 17:29:31 Getting Property ProductName = VMware Infrastructure Management
VMware VirtualCenter-build-84782: 06/24/08 17:29:32 Setting property DatabaseOK =
VMware VirtualCenter-build-84782: 06/24/08 17:29:32 Setting property FORMAT_DB =
VMware VirtualCenter-build-84782: 06/24/08 17:29:32 Setting property LAUNCHWIZARD =
VMware VirtualCenter-build-84782: 06/24/08 17:29:32 Setting property VPX_START = 1
VMware VirtualCenter-build-84782: 06/24/08 17:29:32 End Logging
-cut-
Andre (confused)
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).
Hi
You're my own personal Jesus.
I deleted the sysadmin rights AND dthe database and created a new one and for whatever reason .... it's working now .....