I got the same "Module failed to load" error as the poster above. There is an error (more than one actually) in the article describing the process (http://support.microsoft.com/kb/927665).
It says to type this line at the command prompt:
regsvr32 driver:\Program Files\Common Files\Microsoft Shared\VC\msdia80.dll
where "driver" is replaced with the drive letter where the user's Program Files folder is located. ("driver" is a typo in the example of the command, it should be "drive" so it matches the instruction on where to move the file.) But Command Prompt treats the space after the word "Program" in the command as the end of the command (at least it does in Windows 8.1).
The path must be contained in quotation marks, like this:
regsvr32 "driver:\Program Files\Common Files\Microsoft Shared\VC\msdia80.dll"
Then it works.
I hope that helps others who are dealing with the frustration of a poorly-edited article.