Remote Desktop Gateway Web service ignores Bypass RD Gateway server for local addresses

I found an issue with 2008 RD Web Access today for one of our clients that was working from home. Their home connection is on the same internal subnet as used in their office.

When connecting via RD Web access he ended up connected via RDP to one of his home machines. Connecting him manually into the Remote Desktop Gateway using his local RDP client was fine if Bypass RD Gateway server for local addresses was unticked. Checking the config on the server I found that the settings RD Web should push to the clients was correct and should have unticked Bypass RD Gateway server for local addresses. However it seems Remote Desktop Gateway Web service ignores Bypass RD Gateway server.
Continue reading

Outlook 2003 Shared Calendar issues when migrating to Exchange 2010

A few users had reported Outlook 2003 Shared Calendar issues when migrating to Exchange 2010. Although Outlook 2003 is “Supported” on Exchange 2010 there are a few issues. The most annoying one I came across was the inability to open more than about 5 shared calendars or mailboxes. Users get a misleading error “The connection to the Microsoft Exchange Server is unavailable. Outlook must be online or connected to complete this action.”
Continue reading

Join multiple cells in Microsoft Excel using the CONCATENATE function

One of my colleagues was setting up around 400 student accounts for the new year today. He had an Excel spreadsheet with Firstname and Lastname in seperate cells A and B and needed to add two more columns with the students login name (cell C) and email address (cell D).

At first he thought this would have to be a manual process until I showed him how to join multiple cells in Microsoft Excel using the CONCATENATE function. The login name had to take the format firstname.lastname and the email address had to be in the format firstname.lastname@schoolname.school.nz.
Continue reading