>>I don't think I have ever tried to install SQL and have it go all the way through with no problems.
Then why did you ask the question in the first place?
Going from a simple technology like VFP to a more complex one like SQL Server will inevitably require some pain.
Some of us think that enduring that pain is justified by the benefits of the new technology, some of us don't.