Archive for the ‘Windows’ Category

Matching windows cluster node ID to physical server

Here’s the Powershell version of matching the node number in Cluster.Log files to the actual cluster node names. Essentially log messages like this one… ERROR_CLUSTER_GROUP_MOVING(5908)’ because of ”Cluster Disk’ is owned by node 1, not 2.’ Inspired by this post using cluster.exe. Get-ClusterNode -Cluster ClusterName | SELECT Name, Id, State | Format-Table -Autosize; Output will […]

What does disk maintenance mode actually do to a Failover Cluster?

In Failover Cluster Manager if you perform the following sequence of actions… Storage > Right Click a Disk > More Actions… > Turn on maintenance for this disk You are presented with the following message in the status bar. Turning on maintenance for a physical disk resource allows the disk to be used by applications […]

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 […]

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) […]