Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Published on Author JFLeave a comment

When using Microsoft SQL Server Import and Export Wizard you might get this error when attempting to import an XLSX file: TITLE: SQL Server Import and Export WizardThe operation could not be completed.ADDITIONAL INFORMATION:The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)BUTTONS:OK This is because the default wizard is launches the 32 bit… Continue reading Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine →

How to CORRECTLY install PHP 7.4.16 for IIS on Windows

Published on Author JFLeave a comment

It is easy to fall into old learnings and habits with Windows because it can be difficult to keep up with the latest methods. Also, you’re not in a position to run PHP on a linux stack, so Windows it is. If you’ve been around Windows and IIS for a long time, you might still… Continue reading How to CORRECTLY install PHP 7.4.16 for IIS on Windows →

Add random string to a field using SQL Update

Published on Author JFLeave a comment

Here’s a simple script to add a random string to a SQL Update: update <dbname>set <field> = (SELECT SUBSTRING(CONVERT(VARCHAR(40), NEWID()),0,9)) This will update each row with a distinct 8 alphanumeric characters, e.g. C2552926 Breaking this down in terms of functionality: NEWID() – generates a UUID VARCHAR(40) – tells CONVERT() what string data type, max len… Continue reading Add random string to a field using SQL Update →

Windows 2016 – Windows Cannot Access…

Published on Author JFLeave a comment

Accessing Network Status and other features as Administrator generates this error C:\windows\system32\control.exe Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item. How to solve the problem Run > gpedit.msc Computer Configuration->Windows Settings->Security Settings->Local Policies->Security Options Enable “User Account Control: Admin Approval Mode for the… Continue reading Windows 2016 – Windows Cannot Access… →

Add additional SSH user to Amazon Lightsail

Published on Author JFLeave a comment

Configuring Lightsail Network To make sure you can connect, make sure that Port 22 (default) is open. If you have a fixed IP address, make sure to check “Restrict to IP address” and add your address/es. Remotely Connecting Before we set up the server, let’s go over a couple key items: You’ve create the instance… Continue reading Add additional SSH user to Amazon Lightsail →

Linux tail -f replacement on Windows

Published on Author JFLeave a comment

Use Get-Content and Get-Item in Powershell Looking for the tail command on Windows? Get-Content will do the trick. Here’s a link to the command page. Open PowerShell: Show the last line/s: Get-Content C:\inetpub\logs\LogFiles\W3SVC1\u_ex200711.log -Tail 1 Or use get-item Get-Item -Path .\LineNumbers.txt | Get-Content -Tail 1 Stream the file like tail -f Get-Content path-to-file -wait Example:… Continue reading Linux tail -f replacement on Windows →

How to assign a static IP to Windows 10 Pro HyperV Guest

Published on Author JFLeave a comment

Microsoft Widows 10 Pro (currently 2004 20H1 May 2020 Update 19041) has the ability to run HyperVs. By default, HyperVs will use the internal “Default Switch” for network connectivity and provide DHCP for the VM. It is possible, instead, to create and external switch that will then pull from your network to get DHCP. Be… Continue reading How to assign a static IP to Windows 10 Pro HyperV Guest →

How to turn on TLS 1.2 in Windows 2019

Published on Author JFLeave a comment
Windows 2019 TLS 1.2

Update the Windows Registry Start > Run > regedit Registry path: HKLM SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols Open TLS 1.2 For both Client and Server, double click Enable and set the REG_DWORD to 1. Click Ok, then reboot (but see below first). Lockdown various protocols for IIS While you’re configuring TLS, you may as well lock down IIS. The… Continue reading How to turn on TLS 1.2 in Windows 2019 →

Windows 2019 Change Product Key Not Working

Published on Author JFLeave a comment
Windows 2019 Activation

After installing Windows 2019 you may not be able to activate it with the default product key. When you click “change product key” in the activation screen nothing happens. Solution: change it from the CMD line. You will get popups each time you run these commands. Open CMD > Shift + Right Click > Run… Continue reading Windows 2019 Change Product Key Not Working →