Re: [WiX-users] Multilingual Bundles
Ok I see. For e.g. satellite assemblies ok. But I think at the localized strings e.g. for the main exe related to a) File Extension Registration b) Ugly but sometimes used: CustomAction strings which need localization Here working with Satelite MSIs or duplicating the installer logic across several MSIs or transforming an MSI seems not the first choice... Not sure whether I missed additional points where embedded MSIs should have additional String localization. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Debugging installer
Hi all, We have a solution with a WIX installer project that should install a Windows service and start it right away. Now the issue is that the WIX project outputs MSIs that sometimes fail on some, but not all of our environments. After enabling verbose logging and looking at the log files msiexec.exe, we can see, that each time the installation fails after aquiring the 32 bit elevated custom action server, right when the installer tries the following: Executing op: ServiceInstall(Name=___,DisplayName=_,ImagePath=_,ServiceType=16,StartType=2,ErrorControl=32768,,Dependencies=[~],,StartName=NT AUTHORITY\SYSTEM,Password=**,Description=_,,) The following log entry is: Error 1923. Service '_' (___) could not be installed. Verify that you have sufficient privileges to install system services. The privileges - of course - are not the issue. Comparing logs of failed and successful installs reveal no relevant difference up until the point when the ServiceInstall custom action fails. All differences are timestamps, random character sequences (GUIDS, temporary file names, etc) or PIDs. We are completely puzzled why one MSI fails and the next one does not (no code changes at all, the files seem to be of the same size). Can someone here give us advice what the best course of action would be that would let us closer to the underlying issue? Is there any way to debug the ServiceInstall action? Thank you, Gabor -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Virtual Directory not getting converted to Application in IIS.
Hi All, Anyone have any idea about how to do this? Please someone help me. All helps appreciated. Thank you Regards Tony On Wed, Jul 30, 2014 at 11:32 AM, Tony Jose Mampilly kooltonyj...@gmail.com wrote: Hi, I created a web setup referring to article at *http://www.wintellect.com/blogs/jrobbins/web-application-installer-in-wix http://www.wintellect.com/blogs/jrobbins/web-application-installer-in-wix. *The web setup works fine when executed from an elevated command prompt. An issue I face is that *when I am installing the setup under a different website, then the virtual directory is not getting converted to application,* whereas if I am installing it under default website it is installing properly and also converted to application. What am I missing out to convert it to application when installed under a different website. The code can be obtained from the above link. Any help appreciated. Thanks in advance Regards Tony -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Burn/bundle EXE - setting property?
Hi Sean, Thank you, that fixed the dummy app, however I had tried that in my actual bundle but it did help me to figure out what was wrong, it was a problem with the registry search / key and it was breaking the variable, apologies all for this, and thank you very much for helping me resolve this issue! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Burn-bundle-EXE-setting-property-tp7595178p7596224.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Uninstall with different Bundle
Hi, Someone please tell , why I am not able to uninstall my bundled packages using a newly build bundle (version and upgrade code is same) ? ie I have installed the package using a different build and tried to uninstall with a new build and there are no changes made in values. Thanks and Regards Amal VR -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Uninstall-with-different-Bundle-tp7596225.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unbinder.Unbind error
Yes, I figured out as much, but the error condition that results is not exactly clear. Is this under any control that could make this a bit cleaner? At first I thought it meant the image of the EXE I was debundling, for example! Keith Douglas Statistics Canada | 170 Tunney's Pasture Driveway, Ottawa ON K1A 0T6 Statistique Canada | 170, promenade Tunney's Pasture, Ottawa ON K1A 0T6 keith.doug...@statcan.gc.ca Telephone | Téléphone 613-854-5589 Facsimile | Télécopieur 613-951-4674 Government of Canada | Gouvernement du Canada -Original Message- From: Rob Mensching [mailto:r...@firegiant.com] Sent: August-01-14 7:15 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] Unbinder.Unbind error Winterop.dll is a 32-bit so your calling assemblies need to stay 32-bit not get JIT'd to 64-bit. ___ FireGiant | Dedicated support for the WiX toolset | http://www.firegiant.com/ -Original Message- From: keith.doug...@statcan.gc.ca [mailto:keith.doug...@statcan.gc.ca] Sent: Friday, August 1, 2014 10:51 AM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Unbinder.Unbind error Update: this seems to happen because I was suddenly running a x64 version of things - I had the project set to build as AnyCPU. This is very strange - I understand the library is 32 bit, but why should it fail with the exception mentioned? That's pretty obscure. (If it is clearer in WiX 3.7, ok ...) Keith Douglas Statistics Canada | 170 Tunney's Pasture Driveway, Ottawa ON K1A 0T6 Statistique Canada | 170, promenade Tunney's Pasture, Ottawa ON K1A 0T6 keith.doug...@statcan.gc.ca Telephone | Téléphone 613-854-5589 Facsimile | Télécopieur 613-951-4674 Government of Canada | Gouvernement du Canada -Original Message- From: keith.doug...@statcan.gc.ca [mailto:keith.doug...@statcan.gc.ca] Sent: August-01-14 1:21 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Unbinder.Unbind error A while ago I built some stuff to investigate properties of a burn bundle (EXE) just in case they got lost when we built them, and also to harvest from others (in case we have some bundles not built by us). As per the list's recommendations, I added a reference to wix.dll and kept winterop.dll near by. The POC code looks like (fileName as a parameter from elsewhere) Dim b As New Microsoft.Tools.WindowsInstallerXml.Unbinder Dim out As Microsoft.Tools.WindowsInstallerXml.Output = b.Unbind(fileName, Microsoft.Tools.WindowsInstallerXml.OutputType.Bundle, c:\scratch\) For a while, this worked; some directories of XML and such were created I was able to read from. Now something (not this part of the code, since I haven't touched it) has changed and I get : An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) Stack trace: at Microsoft.Tools.WindowsInstallerXml.Cab.Interop.NativeMethods.ExtractCabBegin() at Microsoft.Tools.WindowsInstallerXml.Cab.WixExtractCab..ctor() at Microsoft.Tools.WindowsInstallerXml.BurnReader.ExtractUXContainer(String outputDirectory, String tempDirectory) at Microsoft.Tools.WindowsInstallerXml.Unbinder.UnbindBundle(String bundleFile, String exportBasePath) at Microsoft.Tools.WindowsInstallerXml.Unbinder.Unbind(String file, OutputType outputType, String exportBasePath) at InstallerBuilder.PackageRepresentation..ctor(String fileName, String notesText, String whoBy) in C:\Users\dougkei\Downloads\DEV\ToolBox3\InstallerBuilder-branch\DeploymentManagement\Business Classes\PackageRepresentation.vb:line 169 C:\Users\dougkei\Downloads\DEV\ToolBox3\InstallerBuilder-branch\DeploymentManagement\Business Classes\PackageRepresentation.vb:line 169 This exception occurs with every bundle I've tried, including one that I just built to make sure it wasn't somehow wrong previously. Any idea what could be going wrong here? I have moved recently to Windows 7 x64, if that matters somehow. Keith Douglas Programmer Analyst | Programmeur analyste Questionnaire Development Services - CAI Social | Services de développement de questionnaires - IAO Social Jean Talon Building | Immeuble Jean-Talon / Floor | Étage 4 A-3 Statistics Canada | 170 Tunney's Pasture Driveway, Ottawa ON K1A 0T6 Statistique Canada | 170, promenade Tunney's Pasture, Ottawa ON K1A 0T6 keith.doug...@statcan.gc.ca Telephone | Téléphone 613-854-5589 Facsimile | Télécopieur 613-951-4674 Government of Canada | Gouvernement du Canada -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds
Re: [WiX-users] Prevent old InstallShield version from installing over WiX
The design of the 'old' install would have to be changed to check for the existence of the the new install, which is probably not feasible. I am not aware of anything that can be done in this situation. It is part of the price that is paid in transitioning from one design to a different design. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Prevent-old-InstallShield-version-from-installing-over-WiX-tp7596218p7596227.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] [Released Spam | pourriel affranchi] Debugging installer
I'm not sure if it is applicable in your case, but I seem to remember that when debugging both our service and our installer for it that if you crash the OnStart method or the constructor you'll also get error 1923. So it might be useful to instrument your service too and see if you can figure out if it gets to anywhere useful. (We are using a managed service, so it might be different if you are not.) Keith Douglas Statistics Canada | 170 Tunney's Pasture Driveway, Ottawa ON K1A 0T6 Statistique Canada | 170, promenade Tunney's Pasture, Ottawa ON K1A 0T6 keith.doug...@statcan.gc.ca Telephone | Téléphone 613-854-5589 Facsimile | Télécopieur 613-951-4674 Government of Canada | Gouvernement du Canada -Original Message- From: Gábor Zoltán Tamás [mailto:tamas.gabor.zol...@gmail.com] Sent: August-05-14 5:11 AM To: wix-users@lists.sourceforge.net Subject: [Released Spam | pourriel affranchi] [WiX-users] Debugging installer Hi all, We have a solution with a WIX installer project that should install a Windows service and start it right away. Now the issue is that the WIX project outputs MSIs that sometimes fail on some, but not all of our environments. After enabling verbose logging and looking at the log files msiexec.exe, we can see, that each time the installation fails after aquiring the 32 bit elevated custom action server, right when the installer tries the following: Executing op: ServiceInstall(Name=___,DisplayName=_,ImagePath=_,ServiceType=16,StartType=2,ErrorControl=32768,,Dependencies=[~],,StartName=NT AUTHORITY\SYSTEM,Password=**,Description=_,,) The following log entry is: Error 1923. Service '_' (___) could not be installed. Verify that you have sufficient privileges to install system services. The privileges - of course - are not the issue. Comparing logs of failed and successful installs reveal no relevant difference up until the point when the ServiceInstall custom action fails. All differences are timestamps, random character sequences (GUIDS, temporary file names, etc) or PIDs. We are completely puzzled why one MSI fails and the next one does not (no code changes at all, the files seem to be of the same size). Can someone here give us advice what the best course of action would be that would let us closer to the underlying issue? Is there any way to debug the ServiceInstall action? Thank you, Gabor -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Prevent old InstallShield version from installing over WiX
Depends on what the old install looked like, as far as it's upgrade table. Did the old install allow for downgrades? If not, did you use the same upgrade code in your WiX install as you had in your install shield installer? -Original Message- From: Mike Schuett [mailto:michael.schu...@hp.com] Sent: Monday, August 04, 2014 5:28 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Prevent old InstallShield version from installing over WiX Hello, I'm migrating an install from MSI based InstallShield to WiX using the standard bootstrapper. Installation of the new product version (WiX based) over older versions (IS MSI based) works fine. The problem I'm having is the old IS installs do not recognize the newer WiX installations and I end up with two installations. Any suggestions would be appreciated. Thanks, Mike -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Prevent-old-InstallShield-version-from-installing-over-WiX-tp7596218.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Debugging installer
A procmon log would be interesting but huge... Just a guess, but it may be possible that the SCM is locked by another process. On the failing machine, if you uninstall, restart, and then reinstall, does it succeed? -Original Message- From: Gábor Zoltán Tamás [mailto:tamas.gabor.zol...@gmail.com] Sent: Tuesday, August 05, 2014 4:11 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Debugging installer Hi all, We have a solution with a WIX installer project that should install a Windows service and start it right away. Now the issue is that the WIX project outputs MSIs that sometimes fail on some, but not all of our environments. After enabling verbose logging and looking at the log files msiexec.exe, we can see, that each time the installation fails after aquiring the 32 bit elevated custom action server, right when the installer tries the following: Executing op: ServiceInstall(Name=___,DisplayName=_,ImagePath=_,ServiceType=16,StartType=2,ErrorControl=32768,,Dependencies=[~],,StartName=NT AUTHORITY\SYSTEM,Password=**,Description=_,,) The following log entry is: Error 1923. Service '_' (___) could not be installed. Verify that you have sufficient privileges to install system services. The privileges - of course - are not the issue. Comparing logs of failed and successful installs reveal no relevant difference up until the point when the ServiceInstall custom action fails. All differences are timestamps, random character sequences (GUIDS, temporary file names, etc) or PIDs. We are completely puzzled why one MSI fails and the next one does not (no code changes at all, the files seem to be of the same size). Can someone here give us advice what the best course of action would be that would let us closer to the underlying issue? Is there any way to debug the ServiceInstall action? Thank you, Gabor -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Application pool getting removed when uninstalling an msi.
Hi I want a solution for the below scenario. Step1: Website.msi-- It's purpose is to install a website and create an app pool. At runtime the inputs to this msi are targetdir, websitename, APP POOL name. Step2: Webapplication1.msiit's purpose is install a web application ( virtual directory) under the website from step1. At runtime the inputs to this msi are targetdir, websitename, APP POOL name ( here we are not creating the website/ app pool these are passed as a reference). Step3: Webapplication2.msiit's purpose is install a web application ( virtual directory) under the website from step1. At runtime the inputs to this msi are targetdir, websitename, APP POOL name ( here we are not creating the website/ app pool these are passed as a reference). Issue/ Scenario: When we are uninstalling any of the webappliation1/2, it is removing the app pool also. Due to this the web site is going in to unknown state. Request you let us know, how to mitigate this issue and ensure that when the web application are uninstalled the app pool is not removed. With regards Ajaykumar -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Debugging installer
Maybe this will help? https://support.firegiant.com/entries/24408043-Debug-service-start-failures- ___ FireGiant | Dedicated support for the WiX toolset | http://www.firegiant.com/ -Original Message- From: Gábor Zoltán Tamás [mailto:tamas.gabor.zol...@gmail.com] Sent: Tuesday, August 5, 2014 2:11 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Debugging installer Hi all, We have a solution with a WIX installer project that should install a Windows service and start it right away. Now the issue is that the WIX project outputs MSIs that sometimes fail on some, but not all of our environments. After enabling verbose logging and looking at the log files msiexec.exe, we can see, that each time the installation fails after aquiring the 32 bit elevated custom action server, right when the installer tries the following: Executing op: ServiceInstall(Name=___,DisplayName=_,ImagePath=_,ServiceType=16,StartType=2,ErrorControl=32768,,Dependencies=[~],,StartName=NT AUTHORITY\SYSTEM,Password=**,Description=_,,) The following log entry is: Error 1923. Service '_' (___) could not be installed. Verify that you have sufficient privileges to install system services. The privileges - of course - are not the issue. Comparing logs of failed and successful installs reveal no relevant difference up until the point when the ServiceInstall custom action fails. All differences are timestamps, random character sequences (GUIDS, temporary file names, etc) or PIDs. We are completely puzzled why one MSI fails and the next one does not (no code changes at all, the files seem to be of the same size). Can someone here give us advice what the best course of action would be that would let us closer to the underlying issue? Is there any way to debug the ServiceInstall action? Thank you, Gabor -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Debugging installer
Thank you all for your answers. Turns out the issue probably is that service uninstall is not complete. Sometimes the service seems to be stuck in a marked for deletion state for minutes after running msiexec, and this interfered with the reinstallation. 2014-08-05 16:55 GMT+02:00 Rob Mensching r...@firegiant.com: Maybe this will help? https://support.firegiant.com/entries/24408043-Debug-service-start-failures- ___ FireGiant | Dedicated support for the WiX toolset | http://www.firegiant.com/ -Original Message- From: Gábor Zoltán Tamás [mailto:tamas.gabor.zol...@gmail.com] Sent: Tuesday, August 5, 2014 2:11 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Debugging installer Hi all, We have a solution with a WIX installer project that should install a Windows service and start it right away. Now the issue is that the WIX project outputs MSIs that sometimes fail on some, but not all of our environments. After enabling verbose logging and looking at the log files msiexec.exe, we can see, that each time the installation fails after aquiring the 32 bit elevated custom action server, right when the installer tries the following: Executing op: ServiceInstall(Name=___,DisplayName=_,ImagePath=_,ServiceType=16,StartType=2,ErrorControl=32768,,Dependencies=[~],,StartName=NT AUTHORITY\SYSTEM,Password=**,Description=_,,) The following log entry is: Error 1923. Service '_' (___) could not be installed. Verify that you have sufficient privileges to install system services. The privileges - of course - are not the issue. Comparing logs of failed and successful installs reveal no relevant difference up until the point when the ServiceInstall custom action fails. All differences are timestamps, random character sequences (GUIDS, temporary file names, etc) or PIDs. We are completely puzzled why one MSI fails and the next one does not (no code changes at all, the files seem to be of the same size). Can someone here give us advice what the best course of action would be that would let us closer to the underlying issue? Is there any way to debug the ServiceInstall action? Thank you, Gabor -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Debugging installer
Thank you all for your answers. Turns out the issue probably is that service uninstall is not complete. Sometimes the service seems to be stuck in a marked for deletion state for minutes after running msiexec, and this interfered with the reinstallation. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Application pool getting removed when uninstalling an msi.
Are you installing your Application into a separate App Pool? Quoting Ajaykumar Gajavalli (Wipro Ltd.) v-ajg...@microsoft.com: Hi I want a solution for the below scenario. Step1: Website.msi-- It's purpose is to install a website and create an app pool. At runtime the inputs to this msi are targetdir, websitename, APP POOL name. Step2: Webapplication1.msiit's purpose is install a web application ( virtual directory) under the website from step1. At runtime the inputs to this msi are targetdir, websitename, APP POOL name ( here we are not creating the website/ app pool these are passed as a reference). Step3: Webapplication2.msiit's purpose is install a web application ( virtual directory) under the website from step1. At runtime the inputs to this msi are targetdir, websitename, APP POOL name ( here we are not creating the website/ app pool these are passed as a reference). Issue/ Scenario: When we are uninstalling any of the webappliation1/2, it is removing the app pool also. Due to this the web site is going in to unknown state. Request you let us know, how to mitigate this issue and ensure that when the web application are uninstalled the app pool is not removed. With regards Ajaykumar -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Deploying a website with IIS Extension
Hi there! Could really use some help on the following, been at it for some time now. I'm extending an existing installer that was built years ago in our product, to deploy a new Asp.Net portal on IIS. I have succeeded in deploying the files using the installer but the component that is supposed to configure IIS runs but has no effect on IIS. Let me emphasize that I'm currently only trying to build an initial installer, which will work on a very specific environment (detailed below). The code section for configuring IIS: DirectoryRef Id=PAMPortalDir Component Id=MIMPAMPortalIISConfig Guid=E7A4EF52-69A7-4123-8D6D-B74428D2739B Win64=yes CreateFolder / util:User Id=MIMPAM_AppPool_Account Domain=[MIMPAM_ACCOUNT_DOMAIN] Name=[MIMPAM_ACCOUNT_NAME] Password=[MIMPAM_ACCOUNT_PASSWORD] CreateUser=no FailIfExists=no RemoveOnUninstall=no /util:User iis:WebAppPool Id=MIMPAM.Web.AppPool Identity=other Name=[PAMPortalAppPool] User=MIMPAM_AppPool_Account/ iis:WebSite Id=MIMPAM.Site Description=[MIMPAMSiteName] AutoStart=yes ConfigureIfExists=yes Directory=PAMPortalDir StartOnInstall=yes iis:WebAddress Id=MIMPAM.Web.Address Port=[MIMPAM_PORTAL_PORT] Header=[MIMPAM_HOSTNAME]/ iis:WebApplication Id=PAMPORTAL.Application Name=MIM Privileged Access Management WebAppPool=MIMPAM.Web.AppPool / /iis:WebSite /Component /DirectoryRef The user in util:User is currently hard coded to the server's admin. Log file includes the following regarding the PAMPortalDir component : MSI (s) (94:80) [09:26:39:887]: Executing op: ComponentRegister(ComponentId={E7A4EF52-69A7-4123-8D6D-B74428D2739B},KeyPath=C:\Program Files\Microsoft Forefront Identity Manager\2010\Privileged Access Management Portal\,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=1) 1: {8EB24D93-91BA-435D-BF88-9339C1C46362} 2: {E7A4EF52-69A7-4123-8D6D-B74428D2739B} 3: C:\Program Files\Microsoft Forefront Identity Manager\2010\Privileged Access Management Portal\ The environment I'm trying to install on includes: Win Server 2008 R2, IIS 7.5 The dev environment includes: Wix 3.5.2519.0 Main questions are: -How can I view what the IIS Extension tried to do? Can I view any log file or see details in the event viewer? -Found this property in the log file: 'Property(C): SKIPCONFIGUREIIS = 1', is It relevant for what I'm trying to do? Changed it to 0 and it had no effect. -Last resort: Can you recommend a guide to compile the IIS Extension source code and debug it? I couldn't find anything useful but running the MSI with logging which doesn't tell me what really happened... Any other tip on understanding what happened and debugging the IIS extension will be great. Huge thanks! Amit. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Deploying a website with IIS Extension
Yes. If SKIPCONFIGUREIIS is set, no work will be done. It needs to be unset (have no value or be deleted) for any work to be done. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: Amit Saar [mailto:amits...@microsoft.com] Sent: Tuesday, August 5, 2014 11:57 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Deploying a website with IIS Extension Hi there! Could really use some help on the following, been at it for some time now. I'm extending an existing installer that was built years ago in our product, to deploy a new Asp.Net portal on IIS. I have succeeded in deploying the files using the installer but the component that is supposed to configure IIS runs but has no effect on IIS. Let me emphasize that I'm currently only trying to build an initial installer, which will work on a very specific environment (detailed below). The code section for configuring IIS: DirectoryRef Id=PAMPortalDir Component Id=MIMPAMPortalIISConfig Guid=E7A4EF52-69A7-4123-8D6D-B74428D2739B Win64=yes CreateFolder / util:User Id=MIMPAM_AppPool_Account Domain=[MIMPAM_ACCOUNT_DOMAIN] Name=[MIMPAM_ACCOUNT_NAME] Password=[MIMPAM_ACCOUNT_PASSWORD] CreateUser=no FailIfExists=no RemoveOnUninstall=no /util:User iis:WebAppPool Id=MIMPAM.Web.AppPool Identity=other Name=[PAMPortalAppPool] User=MIMPAM_AppPool_Account/ iis:WebSite Id=MIMPAM.Site Description=[MIMPAMSiteName] AutoStart=yes ConfigureIfExists=yes Directory=PAMPortalDir StartOnInstall=yes iis:WebAddress Id=MIMPAM.Web.Address Port=[MIMPAM_PORTAL_PORT] Header=[MIMPAM_HOSTNAME]/ iis:WebApplication Id=PAMPORTAL.Application Name=MIM Privileged Access Management WebAppPool=MIMPAM.Web.AppPool / /iis:WebSite /Component /DirectoryRef The user in util:User is currently hard coded to the server's admin. Log file includes the following regarding the PAMPortalDir component : MSI (s) (94:80) [09:26:39:887]: Executing op: ComponentRegister(ComponentId={E7A4EF52-69A7-4123-8D6D-B74428D2739B},KeyPath=C:\Program Files\Microsoft Forefront Identity Manager\2010\Privileged Access Management Portal\,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=1) 1: {8EB24D93-91BA-435D-BF88-9339C1C46362} 2: {E7A4EF52-69A7-4123-8D6D-B74428D2739B} 3: C:\Program Files\Microsoft Forefront Identity Manager\2010\Privileged Access Management Portal\ The environment I'm trying to install on includes: Win Server 2008 R2, IIS 7.5 The dev environment includes: Wix 3.5.2519.0 Main questions are: -How can I view what the IIS Extension tried to do? Can I view any log file or see details in the event viewer? -Found this property in the log file: 'Property(C): SKIPCONFIGUREIIS = 1', is It relevant for what I'm trying to do? Changed it to 0 and it had no effect. -Last resort: Can you recommend a guide to compile the IIS Extension source code and debug it? I couldn't find anything useful but running the MSI with logging which doesn't tell me what really happened... Any other tip on understanding what happened and debugging the IIS extension will be great. Huge thanks! Amit. NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Debugging installer
That is a common reason. The underlying issues tend to be: 1. Someone has an open or leaked service handle to the service, and that leaves the service in a disabled state until the handle is closed. If there is code in your install or in a running app that may be doing this, it may be worth looking at. 2. A process that stops being a service may take a while to close down. The service has told Windows it's no longer a service, but if it then does not terminate within a reasonable time there can be issues trying to install the new service. This might be a variation on 1. --- Phil Wilson On Tue, Aug 5, 2014 at 8:20 AM, Gábor Zoltán Tamás tamas.gabor.zol...@gmail.com wrote: Thank you all for your answers. Turns out the issue probably is that service uninstall is not complete. Sometimes the service seems to be stuck in a marked for deletion state for minutes after running msiexec, and this interfered with the reinstallation. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Deploying a website with IIS Extension [P]
Classification: Public Amit, Your component MIMPAMPortalIISConfig on util:User; Take out the following: CreateUser=no FailIfExists=no RemoveOnUninstall=no For web app pool add these two properties somewhere...: Property Id=DOT_NET_VERSION Secure=yes Value=v4.0 / Property Id=MANAGEDPIPELINEMODE Secure=yes Value=Integrated / Then add this to your iis:WebAppPool ManagedPipelineMode=[MANAGEDPIPELINEMODE] ManagedRuntimeVersion=[DOT_NET_VERSION] i.e.: iis:WebAppPool Id=AdminConsoleAppPoolId Identity=other ManagedPipelineMode=[MANAGEDPIPELINEMODE] ManagedRuntimeVersion=[DOT_NET_VERSION] Name=[WEB_SITE_NAME] User=WebAppPoolID_User / For Website, put this property somewhere: iis:WebDirProperties Id=WebDirProperties AnonymousAccess=no BasicAuthentication=no WindowsAuthentication=yes AccessSSL=no Execute=yes Read=yes Script=yes / Add this to your iis:WebSite DirProperties=WebDirProperties I.e.: iis:WebSite Id=AdminConsoleWebSiteId AutoStart=yes DirProperties=WebDirProperties StartOnInstall=yes Directory=DIRECTORY_PATH_SERVER Description=[WEB_SITE_NAME] iis:WebAddress Id=AllUnassigned Port=[WEB_SITE_PORT] / iis:WebApplication Id=AdminConsoleWebAppId Name=MYWebApp WebAppPool=AdminConsoleAppPoolId iis:WebApplicationExtension CheckPath=no Extension=mvc Executable=[FXDIR]aspnet_isapi.dll/ iis:WebApplicationExtension CheckPath=no Extension=aspx Executable=[FXDIR]aspnet_isapi.dll/ /iis:WebApplication /iis:WebSite All together mine looks like this: (don't forget to add a reference to the WIX IIsExtension/UtilExtension DLL's During my install I ask for the webapppool password/username website port/websitename Property Id=WEB_SITE_NAME Secure=yes Value=MYCOMPANY Web Administration Property Id=WEB_SITE_PORT Secure=yes Value=12345 Property Id=WEBAPPPOOL_PASSWORD Hidden=yes Secure=yes/ Property Id=WEBAPPPOOL_USERNAME Secure=yes Property Id=DOT_NET_VERSION Secure=yes Value=v4.0 / Property Id=MANAGEDPIPELINEMODE Secure=yes Value=Integrated / util:User Id=WebAppPoolID_User Name=[WEBAPPPOOL_USERNAME] Password=[WEBAPPPOOL_PASSWORD] / Property Id=FXDIR Value=0 RegistrySearch Id=FxInstallPathRegistry Key=SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full Name=InstallPath Root=HKLM Type=raw/ /Property iis:WebDirProperties Id=WebDirProperties AnonymousAccess=no BasicAuthentication=no WindowsAuthentication=yes AccessSSL=no Execute=yes Read=yes Script=yes / !--Set up the web site for Administrator Console-- Component Id=cmp_IISConfiguration Guid=some guid KeyPath=yes iis:WebAppPool Id=AdminConsoleAppPoolId Identity=other ManagedPipelineMode=[MANAGEDPIPELINEMODE] ManagedRuntimeVersion=[DOT_NET_VERSION] Name=[WEB_SITE_NAME] User=WebAppPoolID_User / iis:WebSite Id=AdminConsoleWebSiteId AutoStart=yes DirProperties=WebDirProperties StartOnInstall=yes Directory=DIRECTORY_PATH_SERVER Description=[WEB_SITE_NAME] iis:WebAddress Id=AllUnassigned Port=[WEB_SITE_PORT] / iis:WebApplication Id=AdminConsoleWebAppId Name=MYWebApp WebAppPool=AdminConsoleAppPoolId iis:WebApplicationExtension CheckPath=no Extension=mvc Executable=[FXDIR]aspnet_isapi.dll/ iis:WebApplicationExtension CheckPath=no Extension=aspx Executable=[FXDIR]aspnet_isapi.dll/ /iis:WebApplication /iis:WebSite iis:WebServiceExtension Id=EnableASPNet4Extension Allow=yes File=[FXDIR]aspnet_isapi.dll Group=ASP.NET v4.0.30319 Description=ASP.NET v4.0.30319 UIDeletable=no/ iis:WebDir Id=WebDirId Path=WebDir DirProperties=WebDirProperties WebSite=AdminConsoleWebSiteId/
[WiX-users] ProviderKey equivalent in Wix3.6?
I dont see the ProviderKey in Wix3.6 hence I would like to know if there is another way to get the same functionality in 3.6 Thank you -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/ProviderKey-equivalent-in-Wix3-6-tp7596241.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Error 2836: The control ChangeButton on the dialog MaintenanceTypeDlg can not take focus
Hello, I was wondering what I need to do to remove this error. I looked online and on this site but haven't found an answer. How do I remove the focus from the ChangeButton? Thanks. I am getting this error in my log file when I run my WiX installer: MSI (c) (40:D0) [15:53:15:156]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2836 DEBUG: Error 2836: The control ChangeButton on the dialog MaintenanceTypeDlg can not take focus The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2836. The arguments are: MaintenanceTypeDlg, ChangeButton, Action 15:53:15: MaintenanceTypeDlg. Dialog created Here is the code from my UserInterface.wxs file. I set ARPNOMODIFY to 1 to disable the Change button on the MaintenanceDlg page: Publish Dialog=MaintenanceWelcomeDlg Control=Next Event=NewDialog Value=MaintenanceTypeDlg1/Publish Publish Dialog=MaintenanceTypeDlg Control=RepairButton Event=NewDialog Value=VerifyReadyDlg1/Publish Publish Dialog=MaintenanceTypeDlg Control=RemoveButton Event=NewDialog Value=VerifyReadyDlg1/Publish Publish Dialog=MaintenanceTypeDlg Control=Back Event=NewDialog Value=MaintenanceWelcomeDlg1/Publish !-- Greys out the 'Change' button on MaintenanceTypeDlg -- Property Id=ARPNOMODIFY Value=1 / -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Unable to execute sql scripts
Hi, I'm new to WIX and I'm having some problems executing SQL scripts. I have looked at a number of posts and none of them have worked. I have also looked for any SQL Server logs that would help and I couldn't find any. The error messages that I'm receiving in the install log are... CreateDatabase: Error 0x80004005: failed to create to database: 'MVDB', error: unknown error Error 26201. Error -2147467259: failed to create SQL database: MVDB, error detail: unknown error. MSI (s) (A4!F4) [13:21:44:978]: Product: Guru 6 -- Error 26201. Error -2147467259: failed to create SQL database: MVDB, error detail: unknown error. CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) My code looks like this... Binary Id=CreateDatabaseSql SourceFile=C:\VS Publish\SQL Scripts\CreateDatabase.sql / Binary Id=CreateUsersSql SourceFile=C:\VS Publish\SQL Scripts\CreateUsers.sql / Binary Id=CreateBaseLineDbSql SourceFile=C:\VS Publish\SQL Scripts\CreateBaseLineDb.sql / Binary Id=RemoveOldContentSql SourceFile=C:\VS Publish\SQL Scripts\RemoveOldContent.sql / Binary Id=UpgradeSql SourceFile=C:\VS Publish\SQL Scripts\Upgrade.sql / Binary Id=AddCompleteMediaSql SourceFile=C:\VS Publish\SQL Scripts\Upgrade.sql / Binary Id=InstallContentSql SourceFile=C:\VS Publish\SQL Scripts\InstallContent.sql / Binary Id=UpdateCustomPlayListSql SourceFile=C:\VS Publish\SQL Scripts\UpdateCustomPlayList.sql / Binary Id=InstallFeaturedContentSql SourceFile=C:\VS Publish\SQL Scripts\InstallFeaturedContent.sql / DirectoryRef Id=SERVER Component Id='Server.exe' Guid='8027388d-0f90-465b-9668-d1388977caaa' File Id='Server.exe' Source='C:\VS Publish\ProgramFiles\Server\Server.exe' KeyPath='yes'/ ServiceInstall Id=ServiceInstaller Type=ownProcess Name=Service DisplayName=Service Description=Provides media distribution, data coordination, and licensing services to the application Start=auto Account=[SERVICEACCOUNT] Password=[SERVICEPASSWORD] ErrorControl=normal / ServiceControl Id=StartService Start=install Stop=both Remove=uninstall Name=Service Wait=yes / util:User Id=SQLUser Name=[ComputerName]\[%USERNAME] CreateUser=no/ sql:SqlDatabase Id=SqlDatabase Database=MVDB Server=.\MVSQLEXPRESS Instance=MVSQLEXPRESS CreateOnInstall=yes DropOnUninstall=yes ContinueOnError=no User=SQLUser sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql / sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql / sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql / sql:SqlScript Id=RemoveOldContent ExecuteOnInstall=yes BinaryKey=RemoveOldContentSql / sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql / sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql / sql:SqlScript Id=InstallContent ExecuteOnInstall=yes BinaryKey=InstallContentSql / sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql / sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql / /sql:SqlDatabase /Component I have also used... util:User Id=SQLUser Name=[%USERNAME] Domain=[ComputerName] CreateUser=no/ I also tried removing the user altogether from the sql:sqldatabase entry. I have checked that all of the network protocols are enabled for the instance and that there is enough disk space for the database. I would appreciate any help!! Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute sql scripts
There are a lot of ways for a SQL database create to fail. The client side messages won't tell you much. Turn on profiling on the server side and look at the server side logs for clues. Usually, the user lacks the necessary permissions and/or roles to create the database and/or run scripts against it. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: garymonk [mailto:g...@gurudental.com] Sent: Tuesday, August 5, 2014 3:58 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Unable to execute sql scripts Hi, I'm new to WIX and I'm having some problems executing SQL scripts. I have looked at a number of posts and none of them have worked. I have also looked for any SQL Server logs that would help and I couldn't find any. The error messages that I'm receiving in the install log are... CreateDatabase: Error 0x80004005: failed to create to database: 'MVDB', error: unknown error Error 26201. Error -2147467259: failed to create SQL database: MVDB, error detail: unknown error. MSI (s) (A4!F4) [13:21:44:978]: Product: Guru 6 -- Error 26201. Error -2147467259: failed to create SQL database: MVDB, error detail: unknown error. CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) My code looks like this... Binary Id=CreateDatabaseSql SourceFile=C:\VS Publish\SQL Scripts\CreateDatabase.sql / Binary Id=CreateUsersSql SourceFile=C:\VS Publish\SQL Scripts\CreateUsers.sql / Binary Id=CreateBaseLineDbSql SourceFile=C:\VS Publish\SQL Scripts\CreateBaseLineDb.sql / Binary Id=RemoveOldContentSql SourceFile=C:\VS Publish\SQL Scripts\RemoveOldContent.sql / Binary Id=UpgradeSql SourceFile=C:\VS Publish\SQL Scripts\Upgrade.sql / Binary Id=AddCompleteMediaSql SourceFile=C:\VS Publish\SQL Scripts\Upgrade.sql / Binary Id=InstallContentSql SourceFile=C:\VS Publish\SQL Scripts\InstallContent.sql / Binary Id=UpdateCustomPlayListSql SourceFile=C:\VS Publish\SQL Scripts\UpdateCustomPlayList.sql / Binary Id=InstallFeaturedContentSql SourceFile=C:\VS Publish\SQL Scripts\InstallFeaturedContent.sql / DirectoryRef Id=SERVER Component Id='Server.exe' Guid='8027388d-0f90-465b-9668-d1388977caaa' File Id='Server.exe' Source='C:\VS Publish\ProgramFiles\Server\Server.exe' KeyPath='yes'/ ServiceInstall Id=ServiceInstaller Type=ownProcess Name=Service DisplayName=Service Description=Provides media distribution, data coordination, and licensing services to the application Start=auto Account=[SERVICEACCOUNT] Password=[SERVICEPASSWORD] ErrorControl=normal / ServiceControl Id=StartService Start=install Stop=both Remove=uninstall Name=Service Wait=yes / util:User Id=SQLUser Name=[ComputerName]\[%USERNAME] CreateUser=no/ sql:SqlDatabase Id=SqlDatabase Database=MVDB Server=.\MVSQLEXPRESS Instance=MVSQLEXPRESS CreateOnInstall=yes DropOnUninstall=yes ContinueOnError=no User=SQLUser sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql / sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql / sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql / sql:SqlScript Id=RemoveOldContent ExecuteOnInstall=yes BinaryKey=RemoveOldContentSql / sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql / sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql / sql:SqlScript Id=InstallContent ExecuteOnInstall=yes BinaryKey=InstallContentSql / sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql / sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql / /sql:SqlDatabase /Component I have also used... util:User Id=SQLUser Name=[%USERNAME] Domain=[ComputerName] CreateUser=no/ I also tried removing the user altogether from the sql:sqldatabase entry. I have checked that all of the network protocols are enabled for the instance and that there is enough disk space for the database. I would appreciate any help!! Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future.
Re: [WiX-users] Unable to execute sql scripts
Thanks for the reply. The database is on the local machine. I'm not sure how to turn on profiling but I will take a look. One thing I forgot to mention is that the scripts will run in SQL Server Management Console under the same user that is in the user element. I was wondering if the user and domain combination on the util:user element was the same as the domain\user that I use to sign in to the database through the console. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596245.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute sql scripts
I changed the util:user to use sa as the user and it worked. So the problem is definitely a permissions issue. The problem is that I have to be able to use Windows authentication. When the database is created the flag is set to create the current user as an administrator (ADDCURRENTUSERASSQLADMIN=True). Also I can see the current user as an administrator. How do I have WIX create the database using the current user? -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596246.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] When trying to execute a SQL script there are garbage characters
I am trying to execute an SQL script that creates a database and when I do I receive the following errors... Error 26204. Error -2147217900: failed to execute SQL string, error detail: Incorrect syntax near '»'., SQL key: CreateDatabase SQL string: USE [master] The CreateDatabase.sql code is... USE [master] GO DECLARE @data_path nvarchar(256); DECLARE @debug_message nvarchar(2048) SET @debug_message = '' IF NOT EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MVDB') AND @data_path = ' ' BEGIN SET @data_path = (SELECT SUBSTRING(filename, 1, CHARINDEX('master.mdf', LOWER(filename)) - 1) FROM master.dbo.sysdatabases WHERE name = 'master'); SET @data_path = @data_path + 'mvdb.mdf'; IF NOT EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'MVDB') BEGIN CREATE DATABASE [mvdb] IF @@ERROR = 0 BEGIN EXEC dbo.sp_dbcmptlevel @dbname='mvdb', @new_cmptlevel=100 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) BEGIN EXEC [mvdb].[dbo].[sp_fulltext_database] @action = 'enable' END ALTER DATABASE [mvdb] SET ANSI_NULL_DEFAULT OFF ALTER DATABASE [mvdb] SET ANSI_NULLS OFF ALTER DATABASE [mvdb] SET ANSI_PADDING OFF ALTER DATABASE [mvdb] SET ANSI_WARNINGS OFF ALTER DATABASE [mvdb] SET ARITHABORT OFF ALTER DATABASE [mvdb] SET AUTO_CLOSE ON ALTER DATABASE [mvdb] SET AUTO_CREATE_STATISTICS ON ALTER DATABASE [mvdb] SET AUTO_SHRINK OFF ALTER DATABASE [mvdb] SET AUTO_UPDATE_STATISTICS ON ALTER DATABASE [mvdb] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER DATABASE [mvdb] SET CURSOR_DEFAULT GLOBAL ALTER DATABASE [mvdb] SET CONCAT_NULL_YIELDS_NULL OFF ALTER DATABASE [mvdb] SET NUMERIC_ROUNDABORT OFF ALTER DATABASE [mvdb] SET QUOTED_IDENTIFIER OFF ALTER DATABASE [mvdb] SET RECURSIVE_TRIGGERS OFF ALTER DATABASE [mvdb] SET READ_WRITE ALTER DATABASE [mvdb] SET RECOVERY SIMPLE ALTER DATABASE [mvdb] SET MULTI_USER END END END As you can see there are no garbage characters ( ) at the beginning of the procedure. Do I have to embed the code for each procedure or is there a way to use an external file? Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/When-trying-to-execute-a-SQL-script-there-are-garbage-characters-tp7596247.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute sql scripts
In my experience, the user for either SQL Authentication or Windows (Integrated) Authentication, must already be defined on the SQL server. In general, SQL Server won't let a party installing a database from an installer bootstrap it's own credentials. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com From: garymonk [g...@gurudental.com] Sent: Tuesday, August 05, 2014 6:25 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Unable to execute sql scripts I changed the util:user to use sa as the user and it worked. So the problem is definitely a permissions issue. The problem is that I have to be able to use Windows authentication. When the database is created the flag is set to create the current user as an administrator (ADDCURRENTUSERASSQLADMIN=True). Also I can see the current user as an administrator. How do I have WIX create the database using the current user? -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596246.html Sent from the wix-users mailing list archive at Nabble.com. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users