The issue may be that a custom action running elevated during an install on a UAC system means "runs with the system account" and that may not have the required database permissions.
Phil Wilson -----Original Message----- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: Wednesday, August 10, 2011 4:27 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Create Database failed 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 errors around the create. I can't find the original blog for this information, but for a login issue there will be two entries in the SQL log: 2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8. 2006-02-27 00:02:00.34 Logon Login failed for user '<user name>'. [CLIENT: <ip address>] The State in the first entry gives the actual error: ERROR STATE ERROR DESCRIPTION 2 and 5 Invalid userid 6 Attempt to use a Windows login name with SQL Authentication 7 Login disabled and password mismatch 8 Password mismatch 9 Invalid password 11 and 12 Valid login but server access failure 13 SQL Server service paused 16 Does not have access to Database 18 Change password required Hope this helps Michael -----Original Message----- From: JesseBearden [mailto:jesse.bear...@oce.com] Sent: Thursday, 11 August 2011 5:46 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Create Database failed I /believe/ my question is: If an installation has InstalledPrivileges="Elevated" then are deferred/impersonated custom actions run with elevated privileges on a UAC enabled environment? My issue is: I've written a small msi that creates a database and runs some scripts. This works fine on Windows 2003, but when I tried to run it on Windows 7 with UAC on I get an error that it was unable to create the database due to insufficient privileges. I know the admin group has rights to the database, but admin group doesn't mean a ton with UAC on(Until you elevate). The specific user running the installation does not have rights to the database other than being part of the admin group, which has rights to the database. The installation runs correctly from an elevated prompt. The odd part is that the uninstall correctly drops the database when launched via right click or add/remove programs, and I'd assume that that requires the same rights. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Create-Database-failed-tp6673860p6673860.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. This email comes from a division of the Invensys Group, owned by Invensys plc, which is a company registered in England and Wales with its registered office at 3rd Floor, 40 Grosvenor Place, London, SW1X 7AW (Registered number 166023). For a list of European legal entities within the Invensys Group, please go to http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77. You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail recept...@invensys.com. This e-mail and any attachments thereto may be subject to the terms of any agreements between Invensys (and/or its subsidiaries and affiliates) and the recipient (and/or its subsidiaries and affiliates). ------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
