DFS Fileshare and Microsoft Office Protected Mode

We recently switched to using DFS for our Fileshares, but quickly ran into a problem with Microsoft Office Documents opening up in "Protected Mode". The reason given was that Word and Excel believed the files originated from the Internet, and therefore was warning users each time they opened a document from the DFS Share. I … Continue reading DFS Fileshare and Microsoft Office Protected Mode

SAGE 200: Adding a Custom Menu Item

Each Sage 2010 User is associated with one or more "Roles". Users with multiple roles can use "Switch Configuration" from the Sage 200 File Menu to choose the most appropriate one. It is the "Role" (set within Sage System Administration) that determines the Menu Items they are presented with. In Order to add a New … Continue reading SAGE 200: Adding a Custom Menu Item

Re-cycling an SBS 2008 SSL Certificate on a WatchGuard Firewall

I recently rolled out the SSL VPN feature on my WatchGuard M200 Firebox. This will replace the SBS 2008 PPTP VPN for Mobile Users. PPTP is no longer regarded as secure. The SSL VPN itself works fine, but the SSL Certificate is "self generated" by the Firebox, so users receive a security warning when they … Continue reading Re-cycling an SBS 2008 SSL Certificate on a WatchGuard Firewall

Office 365: Your Automatic Reply Settings Cannot Be Displayed

We recently decommissioned our aging Exchange 2007 Server and switched to using Office 365 for Email. One quirk of the new system was that some users were having difficulty accessing their Out Of Office (Automatic Reply) Settings when using Outlook 2010 or 2013. Your automatic reply settings cannot be displayed because the server is currently … Continue reading Office 365: Your Automatic Reply Settings Cannot Be Displayed

Watchguard Firebox M200: Unblocking WeTransfer

If you are blocking "Personal Network Storage and Backup" at your Watchguard Firewall, users won't be able to access wetransfer.com. In their own support documentation here, WeTransfer suggested creating the following firewall exceptions: *.wetransfer.com *.we.tl *.amazonaws.com *.wetransfer.net However, this still doesn't prevent the Firebox from dropping the traffic. Below is a table of exceptions I … Continue reading Watchguard Firebox M200: Unblocking WeTransfer

T-SQL: Aggregate Functions; Date Functions; and Group By Statement Woes

When combining Aggregate Functions with Date / Time functions within an SQL Query, you may run into errors relating to the "Group By" statement, such as: "Column is invalid in the select list┬ábecause it is not contained in either an aggregate function or the GROUP BY clause" "Invalid Column Name" "Each GROUP BY expression must … Continue reading T-SQL: Aggregate Functions; Date Functions; and Group By Statement Woes

SQL Server File Locations for Default Instances

Each Instance of SQL Server has its own set of executable files (sqlservr.exe) and data files. The file locations for the default instance are different depending upon the version installed. Essentially, this is to allow multiple versions of SQL Server to happily co-existing on the same server. The table below lists the default file locations … Continue reading SQL Server File Locations for Default Instances