Category Archives: Uncategorized

Add sysadmin role to a user in Microsoft SQL Express

Stop SQLExpress service Run Command Prompt with administrator rights Find your install folder, for example C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn Start SQL Express in single-user mode: sqlservr.exe -sSQLEXPRESS -m”SQLCMD” -c Open another Command Prompt window (with administrator rights) and connect to … Continue reading

Posted in Uncategorized | Leave a comment

ESXi iSCSI datastore no longer mounts after HBA upgrade

For a storage upgrade, I swapped out two HBAs, an SAS9341-8i (SAS3) and a Dell PERC H310 (SAS2).  The 9341 was changed to a 9300-8i and the PERC was replaced with another 9300-8i. The storage was acting as iSCSI targets … Continue reading

Posted in Uncategorized | Leave a comment

PHP 8.0 Upgrade on Ubuntu 18.04 with phpmyadmin

After upgrading to PHP 8.0 and installing phpmyadmin using the official PPA, phpmyadmin would result in a blank page instead of a login.  The apache2 error.log had several lines of : Got error ‘PHP message: PHP Fatal error: Array and … Continue reading

Posted in Uncategorized | Leave a comment

ESXi local datastores missing after ESXi upgrade 6.7 to 7.0

After upgrading to 7.0 the system datastore was missing (attached via SATA).  Related to this article https://jc-lan.org/2017/02/01/poor-performance-in-esxi-6-5-with-jetway-jnf9g-qm77/ I had previously disabled the built in (native) AHCI driver of ESXi due to poor performance.  Enabling it again followed by a reboot … Continue reading

Posted in Uncategorized | Leave a comment

Upgrade from ESXi 6.7 to 7.0 via command line (ssh)

This guide is for upgrading ESXi via the command line. For this guide I upgraded from 6.7.0 Update 3 (Build 16075168) to 7.0.0 (Build 15843807) Steps: Set firewall esxcli network firewall ruleset set -e true -r httpClient Search for the … Continue reading

Posted in Uncategorized | Leave a comment

Change Windows Server 2012 R2 Network Connection from Public to Private

One liner via PowerShell (run as administrator) Change Ethernet 1 as appropriate based on what is shown in Network and Sharing Center Set-NetConnectionProfile -InterfaceAlias “Ethernet 1” -NetworkCategory Private Note: you can also use this command to pull all information Get-NetConnectionProfile … Continue reading

Posted in Uncategorized | Leave a comment

Steps to Create an OS X Bootable ISO (El Capitan Example)

Apple has steps to create a bootable USB (linked below), but not an ISO file. https://support.apple.com/en-us/HT201372 There are also several methods to create an ISO, such as colt2’s method linked below. https://forums.macrumors.com/threads/el-capitan-bootable-dvd.1923931/post-22048516 The steps in this guide are what I … Continue reading

Posted in Uncategorized | Leave a comment

Steps to Upgrade OMV 4.x (Arrakis) to 5.x (Usul)

I had an OMV system running 4.1.35-1 (Arrakis). Initially I tried using the steps from OMV’s ryecoaaron: https://forum.openmediavault.org/index.php?thread/27909-eta-for-omv-5-0-2020-2021-2022/&postID=219830#post219830 (This included having to use a Python fix for the weakref.py error: https://jc-lan.org/2020/04/26/openmediavault-weakref-python-error-when-updating) However my progress came to a halt at this … Continue reading

Posted in Uncategorized | Leave a comment

Windows Installer Coordiantor Hangs on Windows Remote Desktop Servers

Attempting to install an application on Windows Server acting as a RDS resulted in Windows Installer Coordinator hanging indefinitely with the message: Please wait while the application is preparing for the first use followed by the Windows Installer error message: … Continue reading

Posted in Uncategorized | Leave a comment

Unable to remove Floppy Drive from ESXi Virtual Machine

Problem: Removing the floppy drive and saving the VM configuration, the floppy drive would automatically appear again. Solution: Shutdown the VM and unregister it. Manually edit the vmx file, find one or more lines similar to the below and delete … Continue reading

Posted in Uncategorized | Leave a comment