Archive for September, 2022

VMware vCenter OVA

Posted: 09/29/2022 in Uncategorized

Download ISO file:

Open at 7-zip:

lookup for VCSA folder, extract OVA file:

The best way will be to create another account with permissions same as sa.

Run CMD from local admin (not domain account with admin rights!)

Now you may connect by MSSQL Management Studio to MS SQL Database by new account.

net stop MSSQLSERVER
net start MSSQLSERVER /m"SQLCMD"
sqlcmd
1> CREATE LOGIN <<login>> WITH PASSWORD='<<password>>'
2> GO
1> SP_ADDSRVROLEMEMBER <<login>>,'SYSADMIN'
2> GO
1> exit
net stop MSSQLSERVER && net start MSSQLSERVER

root\CIMv2

SELECT Version FROM Win32_OperatingSystem where ((Caption like '%11%') and (ProductType='1'))

Problem:

What generates problem:

C:\Windows\Logs\CBS has files bigger than 5GB

Resolution:

  1. Stop Windows Modules Installer service
  2. Delete content of C:\Windows\Logs\CBS
  3. Delete content of C:\Windows\Temp
  4. Start Windows Modules Installer service