Om ESX hostar skriver ner loggarna i en katalog som heter IP istället för serverns hostnamn. Verifiera så att RDNS fungerar och att man har angivit domän under TCP/IP configuration på Default systemstack (använd Webklienten). Stoppa syslogtjänsten och spara undan gamla kataloger efter omstart så kommer katalogerna ha rätt namn.
Category Archives: VMware
Starta om ESX host management tjänster
Kan behöva göras om man exempelvis har fått en invalid VM.
/sbin/services.sh restart
Can not vmotion VM The virtual machine is installing VMware Tools
Can not vmotion VM The virtual machine is installing VMware Tools and connot initiate a migration operation
When trying to enter a Host into maintenance mode one or more VMs may be stuck in this case we can try and manually vmotion the Stuck VM which may produce the following error.
Currently connected device ‘CD/DVD Drive 1’ uses backing ‘[]
packages/4.1.0/vmtools/windows.iso’, which is not accessible.
The virtual machine is installing VMware Tools and connot initiate a migration operation
Error on PRDSQLRS01:The operation is not allowed in the current state.
Error Stack
Call “VirtualMachine.UnmountToolsInstaller” for object “PRDSQLRS01” on vCenter Server “DALVCS01.infoplex.int” failed.
To get around this without rebooting the Guest VM causing the issue we need to do the following.
1. Disconnect and remove the Host from the Virtual Center (dont worry the VM stays up)
2. Go into tech support console on the host and restart the management agents.
3. Add the Host back into the virtual center
2. Restart the management agents again.
4. Right click on the VM and go to Guest –> End VMWare tools install. wait 30 seconds and try and vmotion it again.
Script för att ändra schema i SQL databas.
/* Genreate schema update script for tables with specific schema name */
USE TestDB
DECLARE @schemaName varchar(50)
set @schemaName = ‘guest’
select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’
FROM sys.tables
WHERE SCHEMA_NAME(schema_id) = @schemaName
/* Genreate schema update script for sp with specific schema name */
USE TestDB
DECLARE @schemaName varchar(50)
set @schemaName = ‘guest’
select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’
FROM sys.procedures
WHERE SCHEMA_NAME(schema_id) = @schemaName
/* Genreate schema update script for view with specific schema name */
USE TestDV
DECLARE @schemaName varchar(50)
set @schemaName = ‘guest’
select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’
FROM sys.views
WHERE SCHEMA_NAME(schema_id) = @schemaName
angsknarren 