So I was asked recently to setup a test environment for one of our CRM applications. So I went ahead and instead of copying the existing Virtual Machine I decided to create a new one from scratch. Installed SQL Server 2012 and the required application files. As I went to install the database onto the … Continue reading "Changing the SQL Server Collation After Installation for SQL Server 2012 or 2014 without re-installation"
During a deployment of Windows or even after Windows is deployed you see an Open File – Security Warning prompt when a .EXE runs (similar to the one on the right). This happens because when you download an .EXE, .ZIP, or .CAB Internet Explorer (as well as Firefox and Chrome) saves what is called a … Continue reading "How to remove the Open File Security Warning Prompt during Driver Deployment or User Login when using MDT or SCCM"
Quick post today, I organise my driver folders into manufacturer and model and then use a task sequence to pick machine specific drivers. Getting the exact model name helps and one day to do that is via a WMI query. It’s a command I try to use quite a bit (and tend to forget the … Continue reading "Getting a machine product name and serial number using WMIC for use with MDT or SCCM"
If you work in a place with a lot of remote users and a password policy with expiration set then you need to give your users a way to reset their passwords. Microsoft ISA / TMG configured with forms based authentication were able to do this out of the box. The good news is Exchange … Continue reading "Enable a user to Change their Password if it has Expired using OWA for Exchange 2010 and 2013"
I’ve recently been contracting out to an educational organisation assisting with their BAU work as well as helping them modernising some of their processes and server environment. I was recently given a trouble ticket where I had to troubleshoot slow external mail flow. They have an ancient spam filtering appliance coupled with an Exchange 2013 … Continue reading "Troubleshooting 4.3.1 Insufficient System Resources Error for External Mail Flow on Exchange 2013"
I was out at a client recently helping to clean up their iMC implementation and make some recommendations regarding their network setup. I was asked if you could look up Switch and Port number location of an end user device like you could in ProCurve Manager (PCM). Sure you can, the feature has been around … Continue reading "Finding the location of a device using an IP or MAC Address in HP intelligent Management Centre IMC (like you could in ProCurve Manager)"
I’ve been helping out a customer build a new MDT deployment environment and move away from Ghost and the 90’s. As they are not going to be implementing Systems Center Configuration Manager and SUP to automatically maintain their images offline any time soon, we need a way to keep their image up to date with … Continue reading "PowerShell Script to Install Updates Offline in a WIM image using DISM"
I was recently helping out a friend who had a KMS server activating their Windows 7 machines but when they started moving their fleet to Windows 8.1 they saw they couldn’t install the KMS Host product key for Windows 8.1 recieving the following error: 0xc004f015: The Software Licensing Service reported that the license is not … Continue reading "Activating Windows 8.1 clients on a KMS Host running Windows Server 2008 R2"
So I’ve been toying with SharePoint 2013 in my lab at home, doing the install and configuration at the moment, setting up my first Site after the initial configuration but noticed that I made a typo in the Database name. So how do I go about fixing or renaming that database in SharePoint and in SQL … Continue reading "How to Rename a SharePoint 2013 Content database name hosted on SQL Server"
I was recently out at a client and they were in the process of getting another link installed, which happened to be Cable internet which they were using for redundancy. We put their cable modem in Bridge mode but the connection wasn’t coming up after connecting everything up. Most cable providers authenticate with certificates and … Continue reading "How to spoof or mimic a hardware or MAC Address of another device on an interface on a FortiGate"