I'm migrating a DB from 2000 to 2008 R2 on Windows server 2008 and have legacy VB components that need to access this via SQLDMO so I've downloaded the 2005 Backwards compatibiity MSI.
When I try to install the MSI I get "This installation package could not be opened. Contact the vendor to verify this is a valid Windows Installer package."
I've found no cases on the web where this MSI doesn't work. Can anyone offer any advice or know how to manually install SQL DMO functionality?