DataSource finds no MSSQL Instances on Windows Server 2012

[gerd...@gmail.com]

Hello Daniel, hello members,

we use the DataSource Custom Action of MsiExt 1.3 in our Product Setup to show all the MSSQL Server Instances of the network in a combobox. This works great on Windows Server 2008 R2 Standard. But on Windows Server 2012 Standard there will be nothing found and there is no exception or error message. We use the WiX Toolset v3.6.3303.1

Has anyone an idea why it doesn't work on Windows Server 2012?

Greetings
Stephan

[Daniel Doubrovkine]

Start by collecting a log with msiexec /l*v. If there's no useful indication there, feel free to open a new issue on Github.

--
You received this message because you are subscribed to the Google Groups "msiext" group.
To unsubscribe from this group and stop receiving emails from it, send an email to msiext+un...@googlegroups.com.
To post to this group, send email to msi...@googlegroups.com.
Visit this group at http://groups.google.com/group/msiext?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

dB. | Moscow - Geneva - Seattle - New York
dblock.org - @dblockdotorg

[gerd...@gmail.com]

Thank you Daniel for your fast reply. I've traced now with the msi logging option and found the following lines regarding this problem:

SQLDMO_ListAvailableSQLServers: MSI Extensions 1.3.529.0
SQLDMO_ListAvailableSQLServers: [SQLDMO_ListAvailableSQLServers] std::exception: 0x80040154 - Error in CoCreateInstance(CLSID_SQLDMOApplication): Class not registered
MSI (c) (6C!F0) [10:16:45:930]: PROPERTY CHANGE: Adding CA_ERROR property. Its value is '0x80040154 - Error in CoCreateInstance(CLSID_SQLDMOApplication): Class not registered'.
CustomAction AsiUI_SQLDMO_ListAvailableSQLServers returned actual error code 1603 but will be translated to success due to continue marking
Action ended 10:16:45: AsiUI_SQLDMO_ListAvailableSQLServers. Return value 1.

Do you have any idea what happens there and why the class is not registered?

[Daniel Doubrovkine]

Looks like SQL DMO has been deprecated in SQL Server 2012 (see http://msdn.microsoft.com/en-us/library/ms162159.aspx for SMO mapping). The "class not registered" says exactly that - DMO is not installed. 

So this will require some non-trivial (re)work. Happy to help anyone wanting to contribute. 

--
You received this message because you are subscribed to the Google Groups "msiext" group.
To unsubscribe from this group and stop receiving emails from it, send an email to msiext+un...@googlegroups.com.
To post to this group, send email to msi...@googlegroups.com.
Visit this group at http://groups.google.com/group/msiext?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Miller, Nick (GE Intelligent Platforms)]

Actually,  I think they stopped distributing DMO and moved to SMO as off SQL 2005. http://msdn.microsoft.com/en-us/library/ms162552(v=sql.90).aspx

We see this in all our installs that don’t have DMO previously installed.

[gerd...@gmail.com]

Thanks for the replies.

Anyhow, is there something to install that DMO will run on a Windows 2012 Server machine (maybe a dll that helps)?

Thanks in advance.

[Daniel Doubrovkine]

I don't know TBH. Try an older version and it might work. I think putting some dev hands on this and rewriting the library to use SMO is the right way to go.

--
You received this message because you are subscribed to the Google Groups "msiext" group.
To unsubscribe from this group and stop receiving emails from it, send an email to msiext+un...@googlegroups.com.
To post to this group, send email to msi...@googlegroups.com.
Visit this group at http://groups.google.com/group/msiext?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.