Heh.  It's a bit rich, really, me telling folk to Do It Properly - I work for the National Health Service, where Doing It Properly far too often Costs Too...

This will not work with domain accounts. The SQL server is a member of a domain, so when a user DOMAIN\FREDBLOGGS tries to connect to the database, the server...

The easiest solution to the problem would be to configure the server as a Domain Controller. However, this is a complete and utter no-no from a security viewpoint.

A DC...

I should add that I've discovered that the collation set moves with the virtual server, so fail-over does still work.  In other words, it's the virtual server that needs reinstalling,...