The blog
Blog
49 IT guides, fixes, and field notes.
Quickbooks – set excel to open with macros enabled when running reports.
Quickbooks typically allows you to open excel reports with macros already enabled. But some of their “other” reports open Excel directly. When it does, it opens the file as a temporary file, and…
Google Play Family Library fails with Minecraft License Error – Android
Minecraft has been a staple in my household for years. It just makes sense our offspring would love it too. We set out to install Minecraft on one of their tablets and to my surprise, no charge, just…
Windows Update KB5009546 Totally jacked up our DC.
This update created a ridiculous amount of BS to fix. It created a reboot loop that allowed for about 2 minutes after logging in, shutdown abort command did not work, renamed the machine in certain…
Excel unable to enable Macros when running QuickBooks Report.
Our most recent edit shows you the folder to specifically trust: http://strongitguy.com/quickbooks-set-excel-to-open-with-macros-enabled-when-running-reports/ User goes to open up an Excel report…
Removing Unfinished files with Backblaze B2 CLI
Step 1: Download Backblaze B2 Command Line Tool Remember DURING install to choose to set PIP environmental Path https://www.backblaze.com/b2/docs/quick_command_line.html or…
Issues setting up Backblaze B2 Command-line and Windows / Python install
I needed to set up the Backblaze B2 command-line tool to remove unfinished files, also known as failed uploads. The only way to clear out “unfinished files” is to run their designated script from the…
DJI Phantom USB Modem for RTK Controller
DJI Phantom 4 Pro RTK – a WORKING dongle, and how we set it up. Company recently purchased a DJI Phantom 4 Pro w/RTK. The Controller requires a USB Dongle to communicate with a cell network to work…
Office 365 Account Error – we can’t get to your account right now
Symptoms: User continued to have issues opening word or excel from SharePoint. At times it would ask for credentials, you would enter a username, then the screen would disappear without a password…
How to configure a Dell DPWC400 NVMe PCIe SSD adapter in RAID 0
How to configure a Dell DPWC400 NVMe PCIe SSD adapter in RAID 0 Open Command Prompt ->Diskpart ->List Disk Disk ### Status Size Free Dyn Gpt ——– ————- ——- ——- — — Disk 0 Online 238 GB 0 B * Disk 1…
Quickbooks and Server 2016 – Internet Security levels are set to High
Running Quickbooks on a Server 2016 Machine After updating Quickbooks, i received the following alert. Internet Security Levels Are Set Too High The security for Microsoft Internet Explorer has been…
Robocopy Hides Destination Folder
The root cause is you are transferring from the root directory. There are many suggestions on how to fix/correct/prevent this but /A-:SH Did not work /A:-SH errors out Excluding “System Volume…
No internet access on virtual machine using Hyper-V
No internet access on virtual machine using Hyper-V You setup Hyper-V but none of your VM’s seem to have internet. You have your ethernet cable in port one, and you have your Hyper-V Virtual Switch…
Finding a Lost E-mail folder in Outlook
An email folder has disappeared from your folders list, and you have searched everywhere for it. Sound familiar? Don’t fret, you are in luck. Step One – Search Search for an email you KNOW is FOR…
Live migration Hyper-V Virtual Machine Fails on move 0x80090302
Trying to move a VM in Hyper-V huh? This error is related to 0x8009030D Move Hyper-V Virtual Machine Fails 0x80090302 The function requested is not supported. There was an error during move…
DJI Assistant 2 error: An app has been blocked for your protection.
The Issue: When running DJI Assistant 2.exe you encounter the following error: User Account Control This app has been blocked for your protection. An administrator has blocked you from running this…
Those mysterious cloudberry errors
Started using cloudberry again. When it works, it works great. But, its awful when it comes to error messages. Going to start listing those errors here, and hopefully what worked to get past it. 3-24…
Delete a stale Domain User From Windows 10
So you want to delete an old user that was part of a Domain from a Windows 10 machine: Two ways to do this: Search -> This PC -> Right click -> Properties -> Advanced system settings -> Advanced Tab…
CRM install fails with: either installed incorrectly or has not been completely uninstalled.
Once Again, Dynamics 365 rears its ugly head. We recently were updated to Dynamics CRM Version 9. Most users were unaffected, and the plugin was able to be updated without issue. However, during 1…
Command to end Unifi service
Error:unifi is still running and cannot be installed Run this command using command promp copy and paste each line in a command prompt window and press enter.cd “%UserProfile%\Ubiquiti UniFi\”java…
Error when expanding partition on CentOS Linux on a Hyper-V virtual machine.
Error when expanding partition on CentOS Linux on a Hyper-V virtual machine. Error creating partition on /dev/sda: Command-line `parted –align optimal –script “/dev/sda” “mkpart \”\” ext2 ******MiB…
Setting up SSL on IIS 10 through Godaddy
We setup an on-premise ticketing system, and we needed to setup an SSL on them. We have the ticketing software on an Amazon EC2 Instance, our DNS nameservers have been set to amazon in Godaddy DNS…
O365 – Email Migration link
When trying to migrate emails from IMAP, POP, etc you get the an error in O365 Admin Center. I was able to complete the transfer via this link: https://portal.office.com/onboarding/mailsetupadvisor#/
Send an Email Using Command Prompt or Batch File Script with PowerShell
This will allow you to to call a powershell script from a batch file that creates and sends an email. You will need: SMTP Outgoing Server SMTP Outgoing Credentials Apply this line to any Batch file…
Disable Windows Anti-Malware Service Executable
Microsoft is driving me crazy with these “forced” features they have been including with windows. An example of this is Window’s Anti-Malware. It runs in the background scanning everything you do.…
Understanding the Differences between Wiping and Formatting Your Hard Drive.
One of the questions I get most often, is what to do with old hardware. With this question, the primary concern is how to format the drive before they discard it. Most people know they need to format…
Disable Clutter through O365 Admin Dashboard with Powershell
Disable clutter on O365 Admin Dashboard Step 1: Run Powershell ISE as Administrator Step 2 – Run: Set-ExecutionPolicy RemoteSigned A popup will occur, choose “Yes to All”. Just make sure you know…
Setting up custom App Passwords in Gmail for smtp email notifications in pfSense
Setting up custom App Passwords in Gmail for smtp notifications in pfSense I needed to setup Custom notifications for pfSense, which requires an smtp account. This process will work for most systems…
Upgrading Team Foundation Server, TFS 2010 to TFS 2017
Upgrading TFS 2010 to TFS 2017 and SQL Server 2008 to SQL Server 2016 The Problem We need to upgrade a physical server, we will call it “Tcode”. Tcode has Server 2008 32bit installed with TFS 2010…
Going into Crisis Mode
Going into Crisis Mode If you have been in IT long enough, you end up experiencing a “Crisis Mode” day. You know, you click a button and immediately all hell breaks loose, then instantly, your brain…
Mount EXT3 or other Linux drive in Windows
Want to be able to connect a drive that’s been formatted under a linux distro? Checkout this program called Ex2Fsd https://sourceforge.net/projects/ext2fsd/ Read and write was between 50-60MB/s vs a…
Additional Commands to Run When Having issues Uninstalling Microsoft O365.
Office 365 issues I’ll tell ya, dealing with Microsoft support can be one of the most frustrating experiences. Not because it sucks, but because it’s so difficult relaying what your issue is. The…
O365 Microsoft Dynamics CRM Plugin fails to Uninstall, Loops
When trying to uninstall office 365 Dynamics 365 Outlook Plugin, it attempts to uninstall, then loops back to trying to install. It never uninstalls. The Fix: Deleting all registry entries fixed the…
Clean Uninstall of Microsoft O365 Dynamics CRM even when Uninstall Tool Fails
Run this tool for uninstalling http://support.microsoft.com/mats/Program_Install_and_Uninstall CRM 2016 download link https://www.microsoft.com/en-us/download/details.aspx?id=50370 CRM 2016 download…
Outlook Stops Working on Load due to clr.dll and Corrupt Profile
Outlook Stops Working on Load due to clr.dll and Corrupt Profile User downloaded a large file, and then ran a program that processes that data, creating even more data, that ultimately filled up the…
How to Uninstall and Reinstall .Net Framework 1.1 – 4.7
Reinstall .Net Framework 4.7 a. First, we must uninstall .NET Framework Download and Run the following tool, it will help you uninstall one or all versions except 4.7.…
Microsoft Dynamics CRM Invalid Argument after Assigning User
Root Cause: ultimately this came down to registry inconsistencies between the 32 and 64 bit versions of office. This user used the 32 bit version for a while, until their usage called for the 64 bit…
Microsoft and their on Premise Licensing Causes issues Installing Office 365 Project and Visio.
The task is installing Project 2016 and Visio 2016 on a computer that also has Office 365 installed. We wanted to use our Volume Licenses, a benefit of our Gold partnership. When installing 32-bit…
RPC Server is Unavailable due to Faulty wlan Driver
Machine: ASUS ROG G752VY Issue: After a restart, when trying to login to a machine local or domain, it gives the error “The RPC server is unavailable”. Would not restart from restart/shutdown window.…
How to setup Office 365 Deployment Tool
Setting up the Office 365 Deployment Tool. Step 1 Download the latest deployment tool, currently that is 201 and can be found here. https://www.microsoft.com/en-us/download/details.aspx?id=49117 It…
Java causing computer not to respond
User Complaint: Computer not responding, running really slow. Troubleshooting: Task manager will not respond. Ran resource monitor by going to run -> resmon.exe Tasklist under CMD showed shows SO…
O365 Creating a Rule for a Shared Email
To create a rule for a shared email account, you must create the rule from your O365 Mail settings. go to Portal.office365.com -> Gear Icon top right -> Mail -> Inbox and Sweet Rules
Cloudberry Unexpected End of Stream Error
Had a user try to do a restore to Virtual Box from an image. In doing so he received a “unexpected end of stream” error. It seems when setting up the plan, under manual restore, we need to choose the…
Deleting a File when the Filename is too Long
How to delete a file when the filename is too long. By creating a temporary substitute drive, we can shorten the file name, allowing you to rename, delete, etc. As you can see in the commands, I…
Synology Unable to Mount Remote Folder
Synology 12 Bay DS1813+ Rack Mount INTEL Atom D2700 2.13 GHz 2048 MB RAM DSM 6.0.3-8754 Update 1 Synology has a remote folder that I am unable to unmount. “Failed to unmount the remote folder. Please…
CrashPlan Cache Folder Filling up Space on Drive.
Issue: Storage space is low Used spacesniffer to analyze folder size. Found Crashplan cache folder was taking up 140GB. C:\ProgramData\CrashPlan\cache Deleted all of the files in the cache folder…
Media Driver Error when Installing Server 2012 on Hyper-V.
The Problem: Trying to install Windows Server 2016 R2 Standard on Hyper-V, I run into this error: Load driver A media driver your computer needs is missing. This could be a DVD, USB or Hard disk…
Create a Bootable Windows 10 USB Disk (Without the Download Tool)
This is a trick to make any Microsoft ISO you need, by “exploiting” the microsoft ISO installer. aka: This is a roundabout way to make the boot disk, when tools like Rufus fail. The Windows USB/DVD…
Annoyingly Silly USB Detection in Virtual Box
I’ve setup a Virtual Machine via VirtualBox that allows me to connect to a separate WiFi network. This allows me to test the VPN, open ports, and other fun things. What should be a simple process,…
Updating or Reinstall of Office 365 Causes Default Mail Client Errors
After upgrading some users to Office 365 x64 we ran into a consistent issue. Each user, upon boot up would receive the following error. Microsoft Office Outlook Either there is no default mail client…