A week ago my system's hard drive suffered a rather tedious hard drive failure, which I was able to resolve but has created some other issues after the fact. The Hard drive developed a fault, and in order to restore my system, I was forced to use BartPE
as a live cd, and transfer the data from the "defective" drive to the new drive. for some reason the defect caused a fault which prevented most Imaging software from being able to image the drive over so I was forced to use XCOPY.
Yes, this actually worked, and as I am writing this post, it is my exact same system that I used last week, with the minor problem of having to reactivate windows when I finally was finished.
However, there apparently is a minor issue with the NTFS security descriptors. I am not surprised, since I was using the BartPE loaded windows system to transfer the files I expected a little "renaming" of security descriptors to occur in the process.
But when faced with the prospect of rebuilding the entire system from scratch, this was a reasonable cost. However, this tragically confused Sql Server.
As we know SQL Server Installs Several Groups into the User And Groups of the system:
View Complete Post