My MSI is running a custom action which uses SQL-DMO through an interop assembly (Interop.SQLDMO.dll). I am creating the MSI with Visual Studio 2010, and getting "[SQL-DMO] This server object is not connected" on
some Windows Server 2008 x64 machines.
The previous version of my MSI was created with Visual Studio 2005 and is successfully installed on the servers which fail to run with the new MSI. Both MSI's use the exact same interop assembly.
I have tried to install SQL Server 2008 Feature Pack April 2007 - with no luck. It seems to me that the problem is related somehow to Visual Studio 2010, because the custom action does run with the older MSI.
View Complete Post