Knowledge Base

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

Troubleshooting Lab Manager database access

Symptoms

  • Initialization wizard appears and attempts to reinstall Lab Manager
  • The Lab Manager service does not start
  • Upgrading the Lab Manager server fails
  • You receive the following error:

    Alert!
    Cannot open database requested in login 'LabManager'. Login fails. Login failed for user 'sa'.

Purpose

This article provides steps to verify that the Lab Manager database is present and working correctly.

Resolution

To verify that the Lab Manager database is present and working:

  1. Verify that the database file exists in %ProgramFiles%\Microsoft SQL Server\MSSQL$VLM\Data\LabManager.mdf.
  2. Check that the database file is available to SQL.

    To check that the database file is available:


    1. Open a command prompt. For more information, see Opening a command or shell prompt (1003892) .
    2. Run the osql -S localhost\VLM -E -d labmanager command.

      • If the response is 1> , the database is present. Run the exit command to quit osql
      • If the response is Cannot open database requested in login 'labmanager'. Login fails. there may be a problem with the Lab Manager database. Restore the database from backup or reinstall Lab Manager.

Additional Information

Tags

upgrade-server  upgrade-server-fails  labmanager-upgrade-fails vcenter-lab-manager

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


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)
Actions