So you're definately using FC? What make/model of HBA do you have? Are those drivers up to date? Are you using multi-path I/O?

I'm suggesting that there may be a problem...

In this context I'm using the phrase out-of-band to mean; using the regular ethernet network to manage the SAN rather than over the fabric with the data. I've seen some...

I'm still thinking it could be SAN related if it's managed out-of-band using the (teamed) NICs. There may still be even be a pathing/host mapping issue. This kind of problem...

Both the nodes OS were installed from original media.

I think I'm going to have to remove the SQL Instance and re-install.

They're both physical boxes. But you might be onto something here, as they came from a "standard" image. It mightnbe that the sysprep System ID generation didn't work correctly. I'll...

I thought I'd used SID security, and I've checked that I'm adding the new node with the same credentials. That's why I thought that the SID mismatch might be something...

I'm now looking at a re-install using a slipstreamed sp3.

How do I change the AD Group that I specified as part of the cluster security policy?

I'm beginning to think I may have to check the AD groups for the service accounts that I used for security on the primary node.

I'll add the service accounts into...

Thanks for taking the time to look BTW.

Here's a log fragment around the error. I can see that there looks like a missing group sid in AD, or is it a local group it's looking for?

Detail.log

2011-09-23 12:15:22...

I tend to get better results with an old-school subquery.

Here's a real-world example where we have an invoice sales table and product costs table with effective-from dates.

We need the most...

OUTER APPLY? I'll be looking that up.

It's a form of correlated subquery

Excellent article.

Last time I did this with SQL2K5 on a W2K3R2 cluster, I found it easier to install to a "lettered" drive for the system databases for my clustered instance....