Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Problem Upgrading VMware vCenter Lab Manager Due to Permission Issues (1011964)

Details

A failure occurs when you access a SQL Server instance or the database when you add permissions during a vCenter Lab Manager installation. This failure is caused by a missing permission in the SQL Express database for the currently logged in user.

Solution

Using SQL Server Management Studio Express, you must add the currently logged in user in HOSTNAME\currentlogonuser to the database with system administrator permissions. See http://msdn.microsoft.com/en-us/library/ms365247.aspx for more information on SQL Server Management Studio Express.

Since this failure occurs after the installer removes the Lab Manager groups from database, you must add VMwareLMClientAccts and VMwareLMServerAccts back with permission to access the Lab Manager database. The installer expects these groups to be present.
 
To add VMwareLMClientAccts and VMwareLMServerAccts:
  1. Install SQL Server Management Studio Express on your Lab Manager host. This installation must be local (for example, local host\Lab Manager).
  2. Click Connect.
  3. In the Object Explorer panel, expand Security.
  4. Expand Logins.
  5. Right click on a login name and select New Login.
  6. In Object Types, select Group.
  7. Select Advanced.
  8. Select Find Now.
    All groups and users appear. You can add the Administrators group or the currently logged in user.
  9. Select and add VMwareLMClientAccts.
  10. Right click VMwareLMClientAccts and select Properties.
  11. In the Default databases drop-down list, select Lab Manager.
  12. Click OK.
  13. For the user mapping, select Lab Manager.
  14. Left click and select sysadmin as the Server Role.
  15. Click OK.
  16. Repeat steps 10 to 15 for VMwareLMServerAccts.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 4 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 4 Ratings
Actions
KB: