Some weeks ago I had to migrate our View databases to another SQL server.
Here´s my little guide to migrate the databases:
- Stop Composer service
- Back up and move the database to the new database server
- Update the database connection with new server [Start > Administrative Tools > Data Sources (ODBC) > System DSN]
- Start Composer service
- Move the database
- Log in to View Administrator and navigate to View Configuration > Event Configuration
- Select “Edit…” in the Event Database section
- Update the fields with information from the new server and hit OK.
When you are trying to unmount/delete a datastore you can get on of the following error messages:
Cannot unmount volume <datastore> because file System is busy
Cannot delete volume <datastore> because file System is busy
To resolve this issue proceed as follows:
If you are not using VSAN:
1. Connect to your ESXi Host via SSH
This Service isn´t enabled by default. You can enable it
a. with the vSphere Client: in the Security Profile in the Configuration tab of your ESXi Host
b with the Web Client: in Manage -> Settings -> Security Profile of your ESXi Host
2. Stop the vsantraces by running the command:
3. Perfom a Refresh for Storage
4. Unmount/Delete the datastore.
5. Start the Service by entering the following command:
To permanently turn off this Service run the following command:
chkconfig vsantraced off
If you are using VSAN:
1. Run this command to change the Location of the VSAN trace:
# esxcli vsan trace set -p <datastore>
2. Unmount/Delete the datastore
Source and further information: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2069171
In some cases it would be good to know that your VMs don´t have an ISO-File or Host device configured e.g. if you want to vMotion some VMs to another Host. Here´s how you could solve this problem:
[vSphere PowerCLI] C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI> Get-VM | Get-CDDrive | Set-CDDrive -NoMedia -Connected:$false -StartConnected:$false -Confirm:$false
Some of you guys are knowing there are posters for reference for the VMware products.
I´ve attached a link to the updated PowerCLI 5.1 reference poster for you.
Here´s a list of links to downloads to create your VI documentation…
The first link also contains a collection to other sites where you can download additional stencil packs.
Some time ago I´ve found some reference cards for vSphere 4.x and 5.x from Forbes Guthrie (vreference.com)
They are quite helpful and Forbes has released them under CC License.
Here are the links to the reference cards:
To fix this you have to go into the registry and look for in the key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet?\Services\ADAM_VMwareVCMSDS\Parameters for Port SSL.
If Port SSL is already there as a string (REG_SZ), delete it and create a new REG_DWORD named Port SSL and set the value to 636 (Decimal). Then you need to restart the two services “Active Directory Web Services” and “VMwareVCMSDS”.
In ESX 4.1, you can extend and add virtual disks to a virtual machine when it is powered on (after installing VMware Tools).
1. Open VMware Infrastructure (VI) Client and connect to VirtualCenter or the ESX host.
2. Right-click the virtual machine.
3. Click Edit Settings.
4. Select the virtual disk you want to increase
5. Increase the size of the disk.
Note: If this option is greyed out then the disk may be running on snapshots or the disk may be at the maximum allowed size depending on the block size of the datastore
6. Follow the steps Increasing the size of a disk partition (1004071) so the guest operating system is aware of the change in disk size.
Note: If you´re using Windows Server 2008 R2 you only have to open Computer Management > Storage > Disk Management and eventually press F5 to refresh the view, right-click on your drive you want to increase, choose Extend Volume… and to follow the instructions given in the wizard.
To be able to copy and paste between the guest operating system and the remote console, you must enable the Copy and Paste options using the vSphere Client.
To enable this option for a specific virtual machine:
1. Log into a vCenter Server system using the vSphere Client and power off the virtual machine.
2. Select the virtual machine and click the Summary tab.
3. Click Edit Settings.
4. Navigate to Options > Advanced > General and click Configuration Parameters.
5. Click Add Row.
6. Type these values in the Name and Value columns:
- isolation.tools.copy.disable – false
- isolation.tools.paste.disable – false
7. Click OK to close the Configuration Parameters dialog, and click OK again to close the Virtual Machine Properties dialog.
8. Power On the virtual machine.
Note: If you vMotion a virtual machine to a host where the isolation.tools.*=”FALSE” is already set, the copy and paste options are automatically activated for that virtual machine.
To enable this option for all the virtual machines in the ESX/ESXi host:
1. Log in to the ESX/ESXi host as a root user and open the /etc/vmware/config file using a text editor.
2. Add these entries to the file:
3. Save and close the file.
The Copy and Paste options are only enabled when the virtual machines restart or resume the next time.
Note: These options do not persist after an upgrade. If you upgrade to a newer version after enabling these options, the changes are lost and you may have to re-enable them.
For more information, see the Limiting Exposure of Sensitive Data Copied to the Clipboard section of the ESX Configuration Guide.
Since the Windows Update service is deactivated in the VMware View environment we have to ‘activate’ and start the service to update the VM.
Here you find some PowerShell?scripts which are starting and stopping this service and you´ll be able to update your VM.
Clear-Host $srvName = 'wuauserv' $servicePrior = Get-Service $srvName '$srvName is now ' + $servicePrior.status Set-Service $srvName -startuptype manual Start-Service $srvName $serviceAfter = Get-Service $srvName '$srvName is now ' + $serviceAfter.status
Clear-Host $srvName = 'wuauserv' $servicePrior = Get-Service $srvName '$srvName is now ' + $servicePrior.status Stop-Service $srvName $serviceAfter = Get-Service $srvName Set-Service $srvName -startuptype disabled '$srvName is now ' + $serviceAfter.status