Hi Kim, I think you still need a CA for enumerating the array returned from the MULTI_SZ; You cannot assume that your instance is the only one installed (or the first in the list).
If you don't want to use a CA then you should register the instance with your application during install in the registry. This way you can check to see if your application is already installed and what instance of SQL it uses. I don't do database updates during the installation of updates since it gives me too much of a hussle when the update fails, or worse, when the database update fails. So I install the new version of my app with the db update scripts in a directory from which a DBTool is run, which comes with the server part of our app. With this DBTool I can also rollback previous versions of the database and the applications/features for a specific database version. -----Original Message----- From: kim [mailto:contactme...@gmail.com] Sent: maandag 7 februari 2011 17:21 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Getting SQL Server instance name? Thanks for your reply! Pally, I did checked the verbose log, and SQLSERVER variable is having name of the instance installed on system. But I need to populate a property with this instancename, which I am not able to get. Albert, Yes I am checking the InstalledInstances in the registry as follows: <Property Id="SQLSERVER"> <RegistrySearch Id="SQLServer" Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server" Type="raw" Name="InstalledInstances"/></Property> But as I mentioned I am not able to get the value in a variable to display in a dialog or do some action based on its value. What I want to do is: 1. Check if SQLServer is installed on target system. If not then install SQLExpress instance by the name of "MyProduct". 2. If SQLServer is already installed, get the instance name. IF the instance name is same as "MyProduct" (created from previous version of my product), then update the database for my application there. 3. If SQLServer is installed, but instance name is different then, install new instance of SQLExpress by name of "MyProduct". The reason of checking this is that I would like to create/update my product's database in a dedicated instance. Kindly advice if this is possible using WIX. Sincere thanks!! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Getting-SQL-Se rver-instance-name-tp5993646p6000819.html Sent from the wix-users mailing list archive at Nabble.com. ---------------------------------------------------------------------------- -- The modern datacenter depends on network connectivity to access resources and provide services. The best practices for maximizing a physical server's connectivity to a physical network are well understood - see how these rules translate into the virtual world? http://p.sf.net/sfu/oracle-sfdevnlfb _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ The modern datacenter depends on network connectivity to access resources and provide services. The best practices for maximizing a physical server's connectivity to a physical network are well understood - see how these rules translate into the virtual world? http://p.sf.net/sfu/oracle-sfdevnlfb _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
