Archive for January 2011

Unable to start Cluster Service on One Node

A Windows Failover Cluster demo I gave a work failed horribly when the same demo the previous week went perfectly. A case of Sod’s Law. For some reason one of the nodes wouldn’t join the cluster. So I was unable to demo the failover process. I first tried starting the cluster service on the dead […]

Backing up the structure of MySQL databases

Warning: count(): Parameter must be an array or an object that implements Countable in /home/fbsqlcom/public_html/ on line 31

Today I wanted a quick and easy way to generate a backup of the structure of all MySQL databases in one easy hit. Here’s a couple of ways you can do this with the tools you’re likely to find everywhere. Firstly, we can use the following query to generate a list of mysqldump commands. The […]

Powershell for Failover Clustering

As it’s looking increasingly likely I’ll be deploying Windows Failover Clustering, as a HA solution at work, I thought it would be prudent to swot up on a little related Powershell. I’ve picked out a few clustering cmdlets that will be helpful for building scripts to manage and monitor a cluster. First things first! If […]

The account is not authorized to log in from this station

During a recent setup of a SQL Server Cluster I received this error when attempting to join a Windows Server 2008 server onto a Windows 2000 domain. To resolve this issue we modify a Local Security Policy on the Windows 2008 box. Click Start > Administrative Tools > Local Security Policy > Local Policies > […]

Windows Server 2008 64 Bit on VirtualBox installation issue.

I’m just starting to explore SQL Server 2008 Clustering and hit this issue when trying to install Windows Server 2008 (64 Bit) in VirtualBox. The below screen, with "Windows failed to start" error, reared its ugly head shortly after booting off the ISO image. Thankfully the solution is quick and easy (once you’ve found it) […]