Try using "msiexec /i <msiname> /l*vx <logname>" to get verbose logs.
I'm not sure on what info the WiX Standard Custom Actions like SqlExtension put into the logs but those options should get everything & might help point out where it's failing. For some reason I've got a feeling there is some Property or variable you may need to set to get the Standard Custom Actions to put more stuff into the logs, not 100% sure on that though & I can't find any reference to it anywhere so I might be mixing it up with something else. Hopefully if it does exist someone else will remember what I'm rambling about & clarify. Palbinder Sandher Software Deployment & IT Administrator T: +44 (0) 141 945 8500 F: +44 (0) 141 945 8501 http://www.iesve.com **Design, Simulate + Innovate with the <Virtual Environment>** Integrated Environmental Solutions Limited. Registered in Scotland No. SC151456 Registered Office - Helix Building, West Of Scotland Science Park, Glasgow G20 0SP Email Disclaimer -----Original Message----- From: Nathan Zaugg [mailto:nza...@gmail.com] Sent: 28 May 2010 19:58 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Detach Databases on Uninstall I am trying to detach databases on uninstall. I know the commands I have work but for some reason this action fails. We're using integrated authentication and I wonder if that might be part of it. I have also tried running osql/sqlcmd as an install action. It didn't work either and it didn't give me anything interesting in the log. Any suggestions? If I run these commands from a command line they work fine. Thanks! Nate <sql:SqlDatabase Id="Master" Server="." Instance="SQLEXPRESS" Database="master" /> <sql:SqlString Id="OfflineQCEW" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="ALTER DATABASE QCEW.Deploy SET OFFLINE WITH ROLLBACK IMMEDIATE" /> <sql:SqlString Id="DetachQCEW" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="EXEC master.dbo.sp_detach_db @dbname = N'[iQFolder]\QCEW.Deploy.MDF'"/> <!--Detach QCEWCommon--> <sql:SqlString Id="OfflineQCEWCommon" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="ALTER DATABASE QCEWCommon SET OFFLINE WITH ROLLBACK IMMEDIATE" /> <sql:SqlString Id="DetachQCEWCommon" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="EXEC master.dbo.sp_detach_db @dbname = N'[iQFolder]\QCEWCommon.MDF'"/> <!--Detach QCEWSecurity--> <sql:SqlString Id="OfflineQCEWSecurity" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="ALTER DATABASE QCEWSecurity SET OFFLINE WITH ROLLBACK IMMEDIATE" /> <sql:SqlString Id="DetachQCEWSecurity" ContinueOnError="yes" ExecuteOnUninstall="yes" SqlDb="Master" SQL="EXEC master.dbo.sp_detach_db @dbname = N'[iQFolder]\QCEWSECURITY.MDF'"/> Action 19:16:00: ExecuteSqlStrings. Executing SQL Strings ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ExecuteSqlStrings: Error 0x80004005: continuing after failure to connect to database: master ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
