Posts from November 2012

Windows Home Server 2011 Cross Subnet Client Computer Backup

Windows Home Server 2011 is a great product for home use, but it’s design is centred around homes with very basic single subnet flat networks.

A lot of home networking devices shipping these days give you the ability to separate your wired network and wireless network into separate VLANs, such as Linksys products which by use 192.168.1.1 for the wired network and 192.168.2.1 for the wireless network by default when the feature is enabled, or there are geeks like me who run their homes like a miniature enterprise with router-on-a-stick topologies or even vast OSI Layer 3 switched networks.

This causes problems for Windows Home Server 2011 Connectors installed on your client computers running Windows XP, 7, 8 or Macs as out of the box, they can’t communicate with the Home Server and complete their daily scheduled backup jobs leaving you unprotected.

Fortunately, this is fixed very easily with a quick Remote Desktop onto the server. It’s wise to point out now that Microsoft don’t support this modification, however it’s such a small change that I would argue Microsoft would be crazy to deny support for an end-user based on the change and it would be very easy to change back to default if they did complain.

  1. Start a Remote Desktop Services session to the server and logon as the Home Server Administrator account.
    (If you are unsure of how to do this, then you can find this elsewhere online. Anyone unsure of using Remote Desktop probably isn’t a great candidate for making firewall configuration changes either).
  2. From the remote session, open Windows Firewall with Advanced Security from Control Panel Administrative Tools.
  3. Scroll through the list of rules until you find the block listing the following services:
    Windows Server Certificate Service
    Windows Server Client Computer Backup
    Windows Server Connect Computer Web Site
    Windows Server Discovery
    Windows Server Mac Web Service
    Windows Server Provider Framework
  4. For each of these services, open the properties, and select the Scope tab.
  5. If you are unsure of the address boundaries of your subnets, then the easiest thing is to change this from Remote IP Address Local Subnet to Remote IP Address Any IP Address, although I don’t recommend this configuration.
  6. If you know the address boundaries of your subnets, then click the Add button and add either the slash notation for the subnet address in the top box, or select This IP Address Range and enter your starting and ending addresses.
    In my case, I added the slash notation of the subnet for my wireless network (eg. 192.168.2.1/24).
  7. Once you have updated the scope, select theOKbutton to commit the change. No server restart, client computer restart or anything else is required to make it work. The server will simply now start accepting connections from the addresses you specified.

It’s worth noting that this change will also now allow you to join clients to the Home Server from your wireless subnet as again, by default, I found you had to resort to a physical connection to get the connector client installed as it wasn’t able to detect the Home Server otherwise.

Missing Patches and Updates in SharePoint

I drafted this post quite a while ago, but I’ve only just got around to completing it and posting it.

Recently, I was completing some out of hours work to apply the August 2012 Cumulative Update to our production SharePoint 2010 SP1 environment.

After completing the installation of the SharePoint 2010 Foundation and SharePoint Server 2010 update packages, I tried to run the SharePoint Products and Technologies Wizard to initiate the timer job that upgrades the database schema, and it wouldn’t run, reporting that one of the servers was missing the updates that I had just installed.

When searching for the answer, I came across SharePoint Management Shell Cmdlet Get-SPProduct -Local. This useful little Cmdlet for PowerShell forces the local installation of SharePoint to rescan all of it’s installed components and by the looks of it, where needed, updates the SharePoint_Config database with the installed updates for the server. Before running the Cmdlet, I did an iisreset /noforce. Doing this ensures that the web applications are in a suitable state and reloaded with all the latest files.

After running these two commands, running the SharePoint Products and Technologies Wizard successfully validated the servers and allowed the wizard to complete.

Windows 8 Battery Life

I wanted to get a quick post out there regarding Windows 8 battery life.

I’ve been at a meeting today where I’ve been using my Windows 8 Lenovo X220. The machine has the standard Lenovo hard disk (and not an SSD like some of my other machines) and has the standard 6 cell battery.

I left the house with this morning with about 80% battery, used the laptop for about four hours for note taking with OneNote 2013 and now I’m at home, I’ve still got 50% battery.

That’s some pretty amazing consumption if you ask me. Give me a 9 cell extended battery and an SSD to replace the rotating disk, and I think I could quite easily get a full days’ compute out of this machine.

SQL Single User Mode Logon Failed

Ran into an issue today with one of our SQL instances where we needed to bring it up in Single User mode to recover the sysadmin role, however every time we tried to login we got the fateful “Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)” error.

Found this great page on MSDN which you should pay close attention to if you are in a clustered environment as we are:

http://msdn.microsoft.com/en-us/library/ms188236.aspx

The important thing to note is that the cluster resource .dll will allows get the first and only connection before you have a hope in hell of getting it. The way around this is to start the MSSQL$INSTANCENAME using the net start command manually on one of the nodes and not using the Failover Cluster Manager.

This will allow you to use sqlcmd to generate the login you need to regain access.

Enjoy 😉