Re: [WiX-users] Running a single MSI on the same machine more than once concurrently

2012-03-14 Thread Michael Osmond
Hi >From experience of shipping to customers an installer that can do both >scenarios, the two part install might be intuitive, but it's a right pain in >practice. I now avoid doing the two part installs if at all possible. Also the single install location is generally much easier if the data

Re: [WiX-users] Registering/Unregistering ActiveX contolrs

2012-03-05 Thread Michael Osmond
PM To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Registering/Unregistering ActiveX contolrs Hi Mike, Thanks for your insights - just a question What tool(s) did you use to find the differences in the registry? Brad. -Original Message

Re: [WiX-users] Registering/Unregistering ActiveX contolrs

2012-03-05 Thread Michael Osmond
Hi Brad, My experience is that you need to work out what the class registrations are (either by Harvesting or otherwise) and do these using the Registry elements in the installation. Doing so gives you "registration" on install and removal afterwards. It's a bit of a pain to setup the first

Re: [WiX-users] unable to start a service through MSI

2012-02-01 Thread Michael Osmond
The error message is pretty generic, the service can't start for almost any reason. We have MSIs that run in full dialog mode so there is a dialog popped when the service fails to start with the error you are seeing in the eventlog, with a retry and cancel options. When you get this dialog go

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-17 Thread Michael Osmond
: 'master' Do you think it is an issue of SqlExtension? Or is it supposed to require TCP/IP enabled even on the same server? -- Yan On Mon, Oct 17, 2011 at 9:54 AM, Michael Osmond wrote: > Hello Yan > > Thanks for letting me know, > > I don't fully know how it finds instanc

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-13 Thread Michael Osmond
** LOGVERBOSE=1 /l*v install_default.log *And this one installs fine (referencing named SQL instance):* msiexec /i sqldatabase.msi SQLSERVER=.\SQLEXPRESS USER=sa PASSWORD=*** LOGVERBOSE=1 /l*v install_named.log Any ideas, people? -- Yan On Sat, Oct 8, 2011 at 12:05 AM, Michael Osmond wrote:

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-12 Thread Michael Osmond
stance, throws an error):* msiexec /i sqldatabase.msi SQLSERVER=. DB=test USER=sa PASSWORD=*** LOGVERBOSE=1 /l*v install_default.log *And this one installs fine (referencing named SQL instance):* msiexec /i sqldatabase.msi SQLSERVER=.\SQLEXPRESS USER=sa PASSWORD=*** LOGVERBOSE=1 /l*v in

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread Michael Osmond
tor can look in the server's error log where a corresponding entry will be written. Could you please point out where I can find this "server's error log" referenced here? -- Yan On Fri, Oct 7, 2011 at 10:12 AM, Michael Osmond wrote: > Hi > > Looks like an Access Denied

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread Michael Osmond
Hi Looks like an Access Denied to me. Try the following to work out what is going on; This is from an MS Blog If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage. Msg 18456, Level 14, State 1, Server , Line 1 Login fa

Re: [WiX-users] Using a batch file (or something else?) do deploy multiple MSI files.

2011-10-03 Thread Michael Osmond
John Have a look at the Start command (help start) which can be used to start and wait in batch files. Michael -Original Message- From: John Bergman [mailto:john.berg...@xpedienttechnologies.com] Sent: Tuesday, 4 October 2011 8:47 AM To: General discussion for Windows Installer XML too

Re: [WiX-users] Upgrading one of multiple installed instances, round 2

2011-09-14 Thread Michael Osmond
Hi Daniel With a Major Upgrade you are essentially installing a new product and uninstalling an old one, so I found the commandline needed the MSINEWINSTANCE=1 set for upgrading the instance. Also try searching the Wix-Users email archive as there are some very good emails on how people have

Re: [WiX-users] Wix CreateDatabase failure to connect to remote SQL Server Express 2005

2011-09-12 Thread Michael Osmond
Hi Rob My experience Error 0x80004005 will be an access denied type error. Check the SQL Management Logs for the SQL instance to see what the error is. Possible issues: * It could be logon (description below on how to diagnose a logon error) * It could be be privilege. * It could be you are

Re: [WiX-users] question in Wix 2.0

2011-08-22 Thread Michael Osmond
Mark Not 100% sure on this answer, but try BuiltIn\NetworkService or [ComputerName]\NetworkService Michael -Original Message- From: Mark Modrall [mailto:mmodr...@mzinga.com] Sent: Tuesday, 23 August 2011 8:00 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-us

Re: [WiX-users] Create Database failed

2011-08-10 Thread Michael Osmond
Hi Not sure what the UAC behaviour is, but our install creates and upgrades databases on 2008, so in theory it is possible. I am assuming you are using SQL Server - you can check if it is permissions type issue by looking in the SQL Management Log - see if there are login problems or other er

Re: [WiX-users] SQL Scripts Question

2011-06-28 Thread Michael Osmond
Hi What I have done, is to have two components for the Database, one is conditioned to be installed if it is a clean install (not a major upgrade) and the other is installed on the major upgrade, not on clean install. The initial table creation script is against the first component, but not th

Re: [WiX-users] Computer Domain and Property(s) Listing

2011-06-21 Thread Michael Osmond
Be carefull using USERDOMAIN, it is the domain of the account that is logged in, which is not necessarily that of the domain the machine is in - for instance if you are logged in as a local account on the machine USERDOMAIN will be the computer name. I have not found an environment variable th

Re: [WiX-users] When the DB creation is complete?

2011-06-16 Thread Michael Osmond
Your CustomAction will need to be a "deferred" custom action, if it is to occur after the database is created. -Original Message- From: Thai-Hoa Nguyen [mailto:taiwa...@hotmail.com] Sent: Friday, 17 June 2011 9:57 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] When the DB cr

Re: [WiX-users] Multiple instance install questions

2011-06-09 Thread Michael Osmond
Hi 1. Is it possible to uninstall just a single instance, if that instance is no longer needed? Yes, Add/Remove programs will do it, or you can use the command line if you know the Instance ProductCode 2. Is it possible to upgrade just a single instance, if needed. Yes, but again you need some

Re: [WiX-users] IUSR

2011-06-01 Thread Michael Osmond
Hi Here is a snipit of how I determine if I should use name\IIS_WPG (IIS6) or builtin\IIS_IUSRS (IIS7) group in our installs. It has to deal with both the domain part and the name. Gets messy because of domain controllers as well. You could take something like this as a starting point. Avo

Re: [WiX-users] Problem with quotes in CustomAction

2011-05-12 Thread Michael Osmond
Hello Kevin I have been able to do a similar thing with no problem. I expand out the command arguments using custom actions and then pass one property through to the ExecCommand This does allow you to see what is happening quite well in the log. My approach:

Re: [WiX-users] dependent features

2011-05-09 Thread Michael Osmond
Not certain, but try saving the Path add string to registry and read it back in on Uninstall. Also if someone adds a Feature through maintenance mode, you can append to the path string. Your biggest issue would be if someone selectively removes a feature. Michael -Original Message

Re: [WiX-users] dependent features

2011-05-09 Thread Michael Osmond
Hi Martin You could build up a single property with the PATH entry you wish to add using a series of Type 51 Custom Actions. Each would add the path option for a feature and be conditioned by the feature state. You then have a single component (linked to you Register Environment Variables fe

Re: [WiX-users] Wix installers and Continuous Integration

2011-04-12 Thread Michael Osmond
Nick I would recommend all Major Upgrade. I started with Minor and then introduced Major upgrade in our products, and currently use a mix of them - which was a mistake. Complete uninstall verses upgrade - it all depends on how you are deploying in production. Whatever you are doing there i

Re: [WiX-users] SqlDatabase install optional and SqlString execute

2011-04-11 Thread Michael Osmond
lve itself before the db is created in the scenario where the db doesn't exist yet. I'm guessing that the locator will be resolved when the first SqlString in the 2nd component tries to run against it? Thanks. -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au]

Re: [WiX-users] SqlDatabase install optional and SqlString execute

2011-04-11 Thread Michael Osmond
? -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: Monday, April 11, 2011 3:46 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SqlDatabase install optional and SqlString execute Mike, SqlDatabase has an option

Re: [WiX-users] SqlDatabase install optional and SqlString execute

2011-04-11 Thread Michael Osmond
Mike, SqlDatabase has an option ConfirmOverwrite, if set to yes the installer will prompt if it finds a database already created, and allows you to cancel or continue. Using this option the installer only needs to deal with option 1 and you get 2 for free. If you want to be defensive agains

Re: [WiX-users] Check if database exists and display message

2011-03-24 Thread Michael Osmond
Not sure, have not done it myself. It really depends on how you want to detect the error and have the user respond to it. -Original Message- From: kim [mailto:contactme...@gmail.com] Sent: Friday, 25 March 2011 8:39 AM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Check

Re: [WiX-users] Check if database exists and display message

2011-03-24 Thread Michael Osmond
There is currently no built in facility that I know of for this. You would need to build a custom action. -Original Message- From: kim [mailto:contactme...@gmail.com] Sent: Friday, 25 March 2011 8:26 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Check if database exists an

Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database

2011-03-17 Thread Michael Osmond
Hi -2147467259 converts to 80004005. Try searching on this value. Michael -Original Message- From: kim [mailto:contactme...@gmail.com] Sent: Friday, 18 March 2011 7:17 AM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL

Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database

2011-03-17 Thread Michael Osmond
Kim I can't see anything wrong with the script. But the error seems to be specifically with the creation of the database itself from the error. Things you could try: 1. Check that your account actually is an administrator in SQL Server. I have not had much experience with Express, but in a

Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database

2011-03-15 Thread Michael Osmond
Kim General guidance. Are you setting the file path for the MDF and LDF files of the database in the WIX code? I can't see this in the emails I get. If so the Account that the SQL Server service logs on as, will need to have write / modify access to the folders in the paths you specify. I

Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database

2011-03-12 Thread Michael Osmond
Hi I suspect the error is that the service account for the SQL Server does not have permissions to the file path to actually create the database files. Your WXS snipit was not visable, so I am guessing that you are specifying a file path for the data file and log file. With SQL Server the ac

Re: [WiX-users] C# Custom Action questions

2011-03-10 Thread Michael Osmond
am not sure how to tackle it if this is indeed the problem. So the element that makes the DLL part of the .msi maybe needs to know about the "bited-ness: of the source and target. All of this is just supposition as I am a relative beginner with WiX. -Original Message- From: Michael

Re: [WiX-users] C# Custom Action questions

2011-03-10 Thread Michael Osmond
Hi Kevin I think your error that it can't find the CA is in the call private static bool CheckCredentials Should be something like: [CustomAction] public static ActionResult CheckCredentials(Session session) The class it is a member of also needs to be public. Note yo

Re: [WiX-users] 64 bit registry issue with CA

2011-03-07 Thread Michael Osmond
You could have two .reg files one for each situation condition the customaction using the Msix64 property. Having said that, would recommend you use the Wix RegistryKey/RegistryValue instead. Michael -Original Message- From: Arun Kumar [mailto:arun_jku...@persistent.co.in] Sent: Tuesd

Re: [WiX-users] Upgrade SQL Database

2011-03-07 Thread Michael Osmond
HI One of two options. My recommendation would be don't use SQL Authentication unless you really need to, or only provide it as an advanced option for SQL upgrades. The SQL tool will use Integrated Auth if the SQL user and password are left blank. That would mean that the user running the upg

Re: [WiX-users] deploying sql server reports using msi

2011-03-02 Thread Michael Osmond
I haven't found it so far. I know some others have done some work around this, but you would have to search for it. We deploy reports via MSI and it's troublesome. My first solution was to get a command process and use rs.exe which is a deployment tool that comes with report server. The mai

Re: [WiX-users] Login failed using User Element, IIS Application pool and SQL Server Login

2011-02-15 Thread Michael Osmond
Hi Two things to consider IIS_USRS is a built in group try not setting the Domain in the group record (that has worked for me on Win7).I don't know if its relevant but it won't work on Windows 2003 Server (it uses a different group). For your user - %USERDOMAIN resolves to the domain of t

Re: [WiX-users] Drop database on Uninstall not working

2011-02-13 Thread Michael Osmond
Hi I'd guess your problem is in the script BEGIN ALTER DATABASE [SOLUTIONDATABASENAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; USE MASTER; DROP DATABASE [SOLUTIONDATABASENAME]; END" Does this work in sql management studio - I would guess you need some go statement

Re: [WiX-users] install location not preserved while upgradation

2011-02-02 Thread Michael Osmond
Hate to say this, but write it to a registry key and read it back is the only way I am aware of to do this. Its not very much XML: You need a component with a registry entry, a property with a registry search. Michael -Original Message- From: Sanjay Rao [mailto:s...@noida.interrasys

Re: [WiX-users] one .wixproj -- two platforms

2011-01-31 Thread Michael Osmond
I not sure this is the best way, but I manually added the following to my solution and project files. I've removed all of the other msbuild properties that are not relevant: The project file effectively defines 4 different configurations as property groups. The property group with no condi

Re: [WiX-users] WiX v3.5 released!

2011-01-31 Thread Michael Osmond
Well done, We are in the process of closing off our migration from WIX 2.0, and I have been pretty impressed with what's in WIX 3.5. Thanks to you and the team Michael -Original Message- From: Rob Mensching [mailto:r...@robmensching.com] Sent: Tuesday, 1 February 2011 1:07 AM To: Gene

[WiX-users] Optional Install or Upgrade

2010-09-14 Thread Michael Osmond
Hello all, I have a need where a package will determine if a previous version exists, and then allow the user the option to upgrade the previous version, or to install the new version side by side with the existing, so both are available. My current thought was to use the Upgrade table to detec

Re: [WiX-users] CreateDatabase custom action error

2010-08-01 Thread Michael Osmond
Hi The actual error from SQL server is -2147567259 - you need to find what this equates to. You can also look in the SQL Server Logs (via SQL Management Studio) it may give some more hints. I suspect you have a permissions issue - either the user running the install does not have sufficient p

Re: [WiX-users] WixFirewallExtension from 3.5

2010-07-19 Thread Michael Osmond
Neil Suggestion (but not tested). Close visual studio, then edit the project file manually. When setting the path use the either the $(SolutionDir) or $(ProjectDir) as the root of the path, so that the project is transportable. Then reopen in Vis studio. Haven't done this with wix project fi

[WiX-users] Auto Restart on Install

2010-07-01 Thread Michael Osmond
Hello Is anyone aware of a setting in Windows that forces a Windows restart after any installation? We have had an instance with a customer where the server restarted after an upgrade, from the logs the restart looks like it was initiated by the user. The update that was run should not requi

Re: [WiX-users] Dependency on Sql Server

2010-06-24 Thread Michael Osmond
Hi Another angle, to determine the location of an instance, connect to the instance and use the SERVERPROPERTY('MachineName') and compare to your local name. You may need to be careful where the instance is running on a cluster. Michael -Original Message- From: Blair [mailto:os...@l

Re: [WiX-users] Detach Databases on Uninstall

2010-06-01 Thread Michael Osmond
Hi Another option to trace this is to use SQL Profiler - it should show the calls being made and any errors occurring. By setting ContinueOnError="yes" any errors will be swallowed (they may be in the log). If you are doing this only to make the uninstall robust against the database not exist

Re: [WiX-users] How to retain feature selection during major upgrade?

2010-05-06 Thread Michael Osmond
Matt Do you have the action MigrateFeatureStates in your Install and UI execution sequences. Michael -Original Message- From: Matt Johnson [mailto:ma...@timeamerica.com] Sent: Friday, 7 May 2010 6:54 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Ho

Re: [WiX-users] Beginner's Question: 32 Bit MSI on 64 Bit OS

2010-03-25 Thread Michael Osmond
d the build targets from any cpu to x86 in our .net compliation, forcing the assmblies to be 32 bit. Its also possible to detect what os you are on in the .net application and to override any redirection in the registry access calls. Dave -Original Message- From: Michael Osmond [mailto

Re: [WiX-users] Beginner's Question: 32 Bit MSI on 64 Bit OS

2010-03-25 Thread Michael Osmond
I found one case where this doesn't work. It seems dotnet apps by default leave it up to the framework to determine if they are 64 or 32 bit. So when you package this as a 32 Bit MSI and install it on a 64 Bit machine the registry settings are redirected to the Wow6432bit node, but when the co

Re: [WiX-users] Create MS SQL Server 2008 database during installation.

2010-03-24 Thread Michael Osmond
Hi Error 0x80004005: failed to create to database: 80004005 - is Access Denied. Regards Michael -Original Message- From: Asiri Wanigarathne [mailto:waas...@gmail.com] Sent: Thursday, 25 March 2010 3:43 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-user

Re: [WiX-users] Is it possible to add a version umber to the built MSI?

2010-03-15 Thread Michael Osmond
Jeff I set the name and version information in the Description field of the Package definition (as well as the version of the Product). This becomes part of the SummaryInfo. This is available through the file properties of the final MSI - ie right click on the MSI, select Properties and go t

Re: [WiX-users] Minor upgrade tutorial

2010-03-15 Thread Michael Osmond
Hi John That is correct for a minor upgrade. You keep the UpgradeCode and ProductCode the same, and the PackageCode and Version must change (see the MSI SDK for details). FindRelatedProducts is not used for a minor upgrade. Also be aware when you start an MSI with a minor upgrade it is act

Re: [WiX-users] Problem installing a .NET installer-based service using InstallUtilLib.dll

2010-02-24 Thread Michael Osmond
I can use that will automatically resolve to the right account name depending on the target platform? If I have to define this property myself, is there a way to automatically set its value depending on the target platform? Thank you, Raz -Original Message----- From: Michael Osmond [m

Re: [WiX-users] Problem installing a .NET installer-based service using InstallUtilLib.dll

2010-02-23 Thread Michael Osmond
Hi I know I am coming in late on this one, so forgive me if I cover something that has already been said. My understanding is that NetworkService came in with Windows 2003 so it is not "native" so to speak to windows 2000/XP. What you could do set the Account to be a property, and depending on

Re: [WiX-users] Deploying SSRS reports using Wix Installer.

2010-01-26 Thread Michael Osmond
I put them to a folder, and then exec RS.exe to call an rss script to do the deployment. This has a number of problems 1. We rely on RS.exe being on the path to find it. This should be the case, but we have had issues particularly where two versions of SQL Server are on the same machine. 2.

Re: [WiX-users] correct syntax for checking component state in condition

2009-12-16 Thread Michael Osmond
Hi & is for features not components I think you want ?component=2 or possiblye NOT ?component=3 (which would cover all of the different not installed situations). Regards Michael From: Amy Rosewater [arosewa...@spectrumhr.com] Sent: Thursday, 17 De

Re: [WiX-users] Instance transforms with the msi

2009-12-07 Thread Michael Osmond
Hi If you are using MSI Instances and installing to different locations, you don't need different component GUIDs for each component in each installed instance and the reference counting seems to work okay. I will be honest and say I don't know how it works under the hood, but it does work.

Re: [WiX-users] How to get USERDOMAIN?

2009-10-22 Thread Michael Osmond
The big issue with %USERDOMAIN is that it is the domain of the user account that is logged on (and running the install). This may not be the Domain you are after. Example: You are installing software on a Server in an Active Directory domain. You want the domain name of AD - but the user ac

Re: [WiX-users] Installer screw up

2009-10-13 Thread Michael Osmond
I have also had a similar experience with a third party MSI, which we fixed by editing the cached copy. The other option you could try is writing a Minor Upgrade for your installer - with the offending condition removed. When you do the minor upgrade you specify the REINSTALLMODE to recache t

Re: [WiX-users] SqlString roleback options

2009-10-12 Thread Michael Osmond
Hi To do the rollback via the WIX Sql tools 1. You need to have a SqlScript or SqlString that has RollbackOnInstall (and maybe RollbackOnReinstall) set. This schedules the Sql to be run when rolling back. It needs to be scheduled prior to the SqlScript that adds the role. The TSQL for the r

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
-farooq -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: Wednesday, October 07, 2009 1:01 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Dominique I think your right that the SPs are s

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
sions of SQLServer. Dominique. -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: 07 October 2009 07:11 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Here's an example of how I creat

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Michael Osmond
---Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: 6. oktober 2009 23:32 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Louis You need to look at SqlDatabase, SqlScript and SqlString. I use S

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Michael Osmond
Louis You need to look at SqlDatabase, SqlScript and SqlString. I use SqlString to create users (with TSQL) and then assign them a role in the target database, as SqlString expands formatted strings. This way I can pass username information into the SQL script as an MSI property. You could a

Re: [WiX-users] How to save connection Information during installation

2009-10-05 Thread Michael Osmond
Code example for understanding this concept? In this case to accomplish Step 1 (Server) with checkbox? Thanks in advance Best Regards Adnan Michael Osmond wrote: > > Hello Adnan > > The way I do this is I bind each of the input values into properties and > then write eac

Re: [WiX-users] How to save connection Information during installation

2009-10-05 Thread Michael Osmond
Hello Adnan The way I do this is I bind each of the input values into properties and then write each property to a registry value, then on upgrade I use the Registry Search facility in MSI to read these properties from the registry back into the properties In most cases I also give the propert

Re: [WiX-users] SQLExtension create database and access denied error

2009-08-31 Thread Michael Osmond
Hi, When SQL Server creates the database files in the O/S it does so using the identity of the SQL Server Service, the Service identity does not have access to your program files area. I suspect you will have big issues trying to create the database in My Documents for this reason. If you a

Re: [WiX-users] failed to connect to database

2009-08-23 Thread Michael Osmond
Xavier The actual connection error is -2147467259, which converts to hex 80040005 which I believe is a generic access denied error. Michael -Original Message- From: BOURDET Xavier [mailto:xbour...@generixgroup.com] Sent: Saturday, 22 August 2009 12:26 AM To: wix-users@lists.sourceforge

Re: [WiX-users] Help: 'Error 26201.Error -2147467259: failed to create SQL database'

2009-08-03 Thread Michael Osmond
John No worries. Sorry I could not think of something more useful. Regards Michael -Original Message- From: John Stevenson-Hoare [mailto:john.stevenson-ho...@ffei.co.uk] Sent: Monday, 3 August 2009 5:21 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Help: 'Error 26201

Re: [WiX-users] Help: 'Error 26201.Error -2147467259: failed to create SQL database'

2009-07-28 Thread Michael Osmond
ave any idea where I should be looking for the Assert that you mention and how I ensure that the custom action is included in the installation? I just can't spot where the code is located in the source tree that defines the custom action nor can I find any documentation to that effect. John Mi

Re: [WiX-users] Help: 'Error 26201.Error -2147467259: failed to create SQL database'

2009-07-27 Thread Michael Osmond
eported nothing. I am still stuck. Is there any way to debug the steps that the installer is performing to see exactly where the error is generated and perhaps try some alternative values? John Michael Osmond wrote: > > John, > > Firstly what value is the property SQLSERVER being se

Re: [WiX-users] Help: 'Error 26201.Error -2147467259: failed to create SQL database'

2009-07-24 Thread Michael Osmond
John, Firstly what value is the property SQLSERVER being set to, and where is it set? If that is okay, then i suspect it is a SQL Express set up issue. The 0x80004005 error could also be an access denied error from the file system - it does not look like you are specifying a path to where t

Re: [WiX-users] Drop SQL Server database during uninstall

2009-06-12 Thread Michael Osmond
Hello Mary, Romeo Try the following: 1. Create a SqlDatabase for Master, that is not under a component (so its just a reference) 2. Under you component for the target database, but not under the SqlDatabase entry for that database, add a SqlString which is run against Master, executed on uni

Re: [WiX-users] SqlDatabase trusted connection

2009-06-09 Thread Michael Osmond
Neil, I am not aware of anyway to use trusted as you indicate (not built in to the WIX CA anyway). In the end you have to have a valid windows user context to use trusted from, so you would still need a password (or security context) to do a runas/switch user type of operation to run as a diff

Re: [WiX-users] SqlDatabase trusted connection

2009-06-09 Thread Michael Osmond
Niel, Two things to consider. 1. My experience is that in the trusted case the connection to SQL is as the user running the MSI. 2. There is also an issue of what you are actually doing in the SQL string/script - if it is doing anything outside of SQL (say a backup) then when it interacts wi

Re: [WiX-users] Preserve registry settings on upgrade

2009-05-13 Thread Michael Osmond
Alex, Use the Registry Search to read the values into Properties before the upgrade, and use the Properties to write the registry settings. Michael From: Alex Ivanoff [alex.ivan...@shavlik.com] Sent: Thursday, 14 May 2009 12:34 AM To: General discussio

Re: [WiX-users] Building MSIs for automated deployment

2009-05-05 Thread Michael Osmond
David, To automate the deployment you need the every build to be able to update the last. I am guessing that because of your versioning of the MSI with the sprint number being the third number, you can't process the install as an upgrade. I am assuming you have authored upgrades into the MSI

Re: [WiX-users] Upgrade Migrate Products Flag or Custom Action

2009-05-04 Thread Michael Osmond
Murray, Try writing the properties into registry values at install and then using the Registry Search to read the values back into properties at the start of an upgrade Michael -Original Message- From: Murray Hipper [mailto:mhip...@snowdengroup.com] Sent: Tuesday, 5 May 2009 3:17 PM T

Re: [WiX-users] Upgrading SQL Server in Wix

2009-05-04 Thread Michael Osmond
Murray I know there is some stuff if you search through the history of this mailing list. I don't know of any tutorials or other info, but that doesn't mean there isn't any. First what runs in an upgrade is really going to depend on if you are doing an MSI Major Upgrade or Minor Upgrade. If

Re: [WiX-users] Condition for detecting minor upgrade

2009-04-22 Thread Michael Osmond
Johan, Here is what I do, I want a welcome dialog for a first time install, upgrade dialog if it is a major or minor upgrade and a maintenance dialog (ie change features) dialog if it is launched from the Add/Remove programs BAYUPGRADELIST is set by FindRelatedProducts Hope this helps Mi

Re: [WiX-users] creatind DB and running SQL script

2009-03-12 Thread Michael Osmond
this... there is no info more than this in eventvwr. Please suggest me any other way to tackle this. or else i would be left to last option of using DTF CA for executing sqlscripts. regards, Akash On Thu, Mar 12, 2009 at 11:04 AM, Michael Osmond wrote: > Akash > > First check the ap

Re: [WiX-users] creatind DB and running SQL script

2009-03-11 Thread Michael Osmond
Akash First check the application event log (for a failure error from MSInstaller), the full text of the SQL error is there (I am assuming that the "Check related errors.." means you are reading this error from the error dialog). I suspect there is an MDF or LDF file hanging around in the SQL Ser

Re: [WiX-users] question about upgrades and instance transforms

2009-02-20 Thread Michael Osmond
Hello Amy, I have been through this, here's my experience. By the way, if some one can tell me there's a better way, I'd love to know. Most of this is not wix specific, but can be implemented with WIX. Some of it is bootstrap stuff. I assume you want to upgrade each instance independentl

Re: [WiX-users] Property value appears blank in SQL statement

2009-02-19 Thread Michael Osmond
Joe, Do you have a Property definition that sets KMFPRODUCTUPGRADE to be Secure. If its not Secure it is not passed to the Execution phase. See SecureCustomProperties Property in the SDK Michael -Original Message- From: Joe Osman [mailto:joe.os...@tait.co.nz] Sent: Friday, 20 Febru

Re: [WiX-users] How to skip a custom action when feature notselected

2009-02-17 Thread Michael Osmond
nent Can you tell me what's the difference between the two and is it important to use two of them together? Thanks. Michael Osmond wrote: > Joe > > Try looking at the SKIPCONFIGUREIIS property (its part of WIX), this > is how I stop the installer from doing the IIS Custom

Re: [WiX-users] How to skip a custom action when feature not selected

2009-02-17 Thread Michael Osmond
Joe Try looking at the SKIPCONFIGUREIIS property (its part of WIX), this is how I stop the installer from doing the IIS Custom action if MainComponent is not selected. -Or

Re: [WiX-users] sql:SqlDatabase drops database on major upgrade

2009-02-17 Thread Michael Osmond
r] IF ('[REMOVE]' = 'ALL' AND '[KMFUNINSTALL]' = 'KMFUNINSTALL') BEGIN ALTER DATABASE $(var.DataBaseName) SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP DATABASE $(var.DataBaseName) END In the execute sequence: Installed AND NOT UPGRADINGPRODUCTCODE

Re: [WiX-users] sql:SqlDatabase drops database on major upgrade

2009-02-16 Thread Michael Osmond
. Based on your suggestion I've created the following sql script: USE [master] GO IF ('[REMOVE]' = 'ALL') BEGIN DROP DATABASE MyDataBase END but the database doesn't get removed on uninstall. How can the sql script determine the value of [REMOVE] on uninstall? T

Re: [WiX-users] sql:SqlDatabase drops database on major upgrade

2009-02-15 Thread Michael Osmond
Joe, I don't think you cam do this in WIX V2 (if that's what you using). Michael -Original Message- From: Joe Osman [mailto:joe.os...@tait.co.nz] Sent: Monday, 16 February 2009 12:14 PM To: General discussion for Windows Installer XMLtoolset. Subject: [WiX-users] sql:SqlDatabase drops

Re: [WiX-users] sql:SqlDatabase drops database on major upgrade

2009-02-15 Thread Michael Osmond
Hello Joe, I've been in a similar situation. The possible solutions I am aware of: 1. If you schedule the DeleteExistingProduct action at the end of the install (I think after the InstallFinalise), my understanding is that the install should calculate that there still is a count of one on the d

Re: [WiX-users] any insights as to why sql extension commands containing public property references are not working

2009-02-11 Thread Michael Osmond
Robert, Just one observation, are you sure that the difference in between using create (in the exampel that works) and wrapping the create inside an exec command (in the example that fails) is not the problem. Both look okay to me, but I have had fun in the past with getting exec('strings') to do

Re: [WiX-users] auto delete on reinstall

2009-02-03 Thread Michael Osmond
Thomas, Removing the old version is important if the new version is structurally different (eg different assembly names, different registry keys, different folder layout). Believe me it happens. To just go over the top look at Minor Upgrades, these work if you are simply refreshing existing f

Re: [WiX-users] Application pool identity is stuffed up on productupgrade - IIS7.0

2009-01-21 Thread Michael Osmond
Joe, How is the Uninstall of the old product version scheduled in the upgrade. My guess is that your update is uninstalling and then installing the web pool and when it reinstalls it, it no longer has the identity to use. Michael -Original Message- From: Joe Osman [mailto:joe.os...@ta

Re: [WiX-users] Prevent reboot.

2009-01-21 Thread Michael Osmond
I bumping into COMs file locks. I guess I'll have to see tomorrow :-) ... pending I get the time. Thanks for your help so far. Adam On Wednesday 21 January 2009 22:59:01 Michael Osmond wrote: > Adam, > > I agree (and our experience bears it out), IIS reset should kill off > any thing that

Re: [WiX-users] Prevent reboot.

2009-01-21 Thread Michael Osmond
too quick to start installing before we its let the service settle (althought like i said I would think its smarter than that) but the website I am a bit stumped with. Adam On Wednesday 21 January 2009 22:10:55 Michael Osmond wrote: > Adam, > > I suspect there is something more goin

Re: [WiX-users] Prevent reboot.

2009-01-21 Thread Michael Osmond
Adam, I suspect there is something more going on here. We have been following a test deployment process like yours for several years for a suite of large web applications, and the only time we have file lock issues is if someone is actively testing (hitting the pages) when the upgrade occurs. M

Re: [WiX-users] Supporting multiple instances (like SQL Server)

2009-01-18 Thread Michael Osmond
Hello Ryan, >From my experience, most of what you want to do in the Install Sequence you actually need to do in the Bootstrap, some of this information is actually required as you start the MSI engine up. You should probably have a read of the MSI SDK which talks about what is need for multiple i

Re: [WiX-users] Getting the version from the Assembly file

2009-01-13 Thread Michael Osmond
Colin, You can set an environment variable in the build process and then access that inside wix as $(env.projectVersion) Or you can set an Wix variable in the candle command line "candle -dMyProject.Version=" Michael -Original Message- From: Colin Fox [mailto:greenene...@gmail.

  1   2   >