Topic
Tech Blog
35 posts
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…
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…
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…
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…
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…
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.…
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…
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 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…