Virtual Centre: Difference between revisions

From vwiki
Jump to navigation Jump to search
m (Minor typo correction)
(Added "Migrate SQL2000 to SQL2005")
Line 50: Line 50:




== SQL Database ==
=== Migrate SQL2000 to SQL2005 ===
This should be fairly painless (so long as your DBA knows his stuff!).
'''Before you start''', you must ensure the Virtual Centre is using a SQL Native Client driver to access the database (see [http://kb.vmware.com/kb/1003391 VMware KB1003391])...
# Open up '''ODBC Data Source Administrator''', and go to the '''System DSN''' tab
# Check that the driver you're using is '''SQL Native Client'''
# If not, you'll need to upgrade...
## Download from Microsoft and install SQL (see the VMware KB link above)
## Stop your Virtual Centre Server service
## Rename your existing DSN (eg append "old" to it)
## Create a new DSN using the new driver but otherwise exactly the same as the previous (the name MUST be the same)
## Restart the Virtual Centre Server service
## Login using the VI Client and ensure everything looks good (clusters, ESX's, VM's, Alarms, Guest Customisations etc)
'''To complete the migration...'''
# Stop the Virtual Centre Server service
# Backup the database (and log files) from your old SQL 2000 server
# Restore the database (and log files) to your new SQL 2005 server
# Ensure that your Virtual Centre's database account is the db_owner of the Virtual Centre database on SQL 2005 (as it was on the SQL2000 database) 
# Change the ODBC DSN settings on the VC server so it points to the SQL 2005 server (just change the server name)
# Restart the Virtual Centre Server service
# Login using the VI Client and ensure everything looks good (clusters, ESX's, VM's, Alarms, Guest Customisations etc)






[[Category:VMware]]
[[Category:VMware]]

Revision as of 09:25, 18 November 2009

Sysprep Setup

The following Sysprep support directories were created during Virtual Center installation, these need to be populated in order for the VC to be able to sysprep VM's as they are deployed using Guest Customisation:

<ALLUSERSPROFILE>\Application Data\Vmware\VMware VirtualCenter\sysprep
...\1.1\
...\2k\
...\xp\
...\svr2003\
...\xp-64\
...\svr2003-64\

where <ALLUSERSPROFILE> is usually C:\Documents And Settings\All Users\. Windows 2008 (and Vista) don’t need sysprep files as the function is built into the OS.

Download the ‘System Preparation Tool’ or ‘Deployment Tools’ package that contains ‘sysprep’ from the Microsoft download centre. Make sure that you download the correct version for the guest operating system and ‘Service Pack’ that you want to customize.

1.1: In the case of the generic version 1.1 simply run the downloaded executable to extract the files then copy the contents of the Tools directory into the appropriate directory (see below).

Windows 2000: In the case of Windows 2000 simply run the downloaded executable to extract the files into the appropriate directory (see below).

Win XP: In the case of XP run the downloaded executable to create deploy.cab then use something like WinZip to extract the files into the appropriate directory (see below).

Windows 2003: In the case of Windows 2003 the downloaded executable is a Hot Fix which must be run (Installed) on a matching OS to create deploy.cab then use something like WinZip to extract the files into the appropriate directory (see below).


Update Manager

Import updates from another VC

Useful when you've a isolated VC (without internet access), and another with a full compliment of updates.

  1. Copy the updates from to the VC, copy the entire Data directory
    • Default location for updates C:\Documents and Settings\All Users\Application Data\VMware\Vmware Update Manager\Data
  2. On the isolated VC, run a version of the following example command to update the Update Manager database
    • vmware-updateDownloadCli -p <path to patches>\Data -f esx -U <user ac>

Scan/Remediate fails

  • Error: VMware Update Manager had a failure
  • Detail: Patch metadata for <ESX> missing, please download patch metadata first, despite the fact that Update Manager is fully up to date.
  • /var/log/vmware/esxupdate.log shows connection errors
  1. On the VC, stop the VMware Update Manager Service
  2. Edit vci-integrity.xml file
    • Normally found in C:\Program Files\VMware\Infrastructure\Update Manager\
  3. Edit the following entry, adding the VC IP address
  4. Restart the VMware Update Manager Service


SQL Database

Migrate SQL2000 to SQL2005

This should be fairly painless (so long as your DBA knows his stuff!).

Before you start, you must ensure the Virtual Centre is using a SQL Native Client driver to access the database (see VMware KB1003391)...

  1. Open up ODBC Data Source Administrator, and go to the System DSN tab
  2. Check that the driver you're using is SQL Native Client
  3. If not, you'll need to upgrade...
    1. Download from Microsoft and install SQL (see the VMware KB link above)
    2. Stop your Virtual Centre Server service
    3. Rename your existing DSN (eg append "old" to it)
    4. Create a new DSN using the new driver but otherwise exactly the same as the previous (the name MUST be the same)
    5. Restart the Virtual Centre Server service
    6. Login using the VI Client and ensure everything looks good (clusters, ESX's, VM's, Alarms, Guest Customisations etc)

To complete the migration...

  1. Stop the Virtual Centre Server service
  2. Backup the database (and log files) from your old SQL 2000 server
  3. Restore the database (and log files) to your new SQL 2005 server
  4. Ensure that your Virtual Centre's database account is the db_owner of the Virtual Centre database on SQL 2005 (as it was on the SQL2000 database)
  5. Change the ODBC DSN settings on the VC server so it points to the SQL 2005 server (just change the server name)
  6. Restart the Virtual Centre Server service
  7. Login using the VI Client and ensure everything looks good (clusters, ESX's, VM's, Alarms, Guest Customisations etc)