SQL code

Updating Tenant Information in System Center 2012 R2 VMM

Q: I'm trying to update a System Center 2012 R2 Virtual Machine Manager tenant with additional virtual networks or templates, but it keeps failing. Why?

A: The most common cause of this problem is that people have applied Update Rollup 1 but haven't applied the required SQL database update. The Microsoft Support article "Description of Update Rollup 1 for System Center 2012 R2 Virtual Machine Manager" specifies the SQL code that needs to be executed. The easiest way to run this code is to connect to SQL Server Management Studio (SSMS), right-click the System Center Virtual Machine Manager database (VirtualManagerDB), select New Query, paste the code from the article, and select Execute.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.