I was getting the following error when I copied the msdia90.dll into the system32 directory:
“The module ‘msdia90.dll’ failed to load. Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL files. The specified module could not be found.”
I then tried registering the dll while it was on the desktop and it worked.