While I have been installing vRA lately as a part of a VMware Validated Design engagement using the Automated Deployment Tool, my vRA deployment tool failed as the DBA has not provided the right permissions on the SQL box required to install vRA. The Error received at that moment was: “Error occurred while executing SQL file: User does not have permission to perform this action.”.  This error showed up in vCAC-Config.log file on the first IaaS web server.

The above error was pretty descriptive and easy to rectify by assigning a sysadmin role to my vRA user account used for the vRA Installation as well provide it with a dbo role on the vRA database. I decided to go ahead and re-run my installation after I have resolved the permissions issue, and I started facing the following error, which I was not clear what’s going on initially: “Another instance of the component is already installed on this server.”

Here is what made this error initially confusing, it comes up as a part of SQL Database creation block. Below how the error looked as the installation was executing:

[root]  [INFO] ———————————————————————————————————————-
[root]  [INFO]         Installation of IaaS “db” component on host “vraweb01.vt.com” starts now
[root]  [INFO] ———————————————————————————————————————-
[root]  [INFO] Executing db Installation command:
[root]  /usr/sbin/vra-command execute –node 574C2057-4BEE-40E0-A163-AD86A1FTT32A install-db –SqlServer vtvrasql01.vt.com,1433 –DatabaseName vRA –DataPath  –LogPath  –UseWindowsAuthentication True –UseExistingDatabase True –UseEncryption False –SqlUser VT\svr_vra –SqlUserPassword *******
[root]  Parent command with id=’3bae80fe-02d2-4ea9-8290-8c2b634d1a5e’ was created.… Read More