>From your log: 1) is 'SqlComponent' being selected for install?
If so, 2) What is the value of the property USEINTEGRATEDSECURITY from the verbose log? Note that this property is going to have to be remembered for repair, upgrade, and patching to work. Note also that it will currently only be evaluated the first time the Component is consider for install since the Component is not marked transitive. This may or may not be what you want. 3) What is the instance you are trying to install to? This method has known issues installing to default instances. I highly recommend installing only to named instances. 4) What are the permissions of the installing user? Some of these scripts appear to require Administrator rights on either the installing compute or the SQL server or both. 5) What does the verbose log look like? Most of these issues can be easily diagnosed from a verbose log, but I'm just guessing without one. In answer to your later post, I have done this many, many times. But I'm currently at the end of a GA cycle on one of my products, and I therefore have limited time. -- John Merryweather Cooper Senior Software Engineer | Enterprise Service Applications | Continuing Development Jack Henry & Associates, Inc.® | Lenexa, KS 66214 | Ext: 431050 |jocoo...@jackhenry.com -----Original Message----- From: garymonk [mailto:g...@gurudental.com] Sent: Friday, October 24, 2014 5:28 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Error "database does not exist" when executing ExecuteSQLStrings I changed my product.was to the following but when I test it it doesn't create the database. I don't receive any errors when I run it, it just doesn't create anything. My product.was... <Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC' KeyPath='yes'> <Condition>USEINTEGRATEDSECURITY = 1</Condition> <sql:SqlDatabase Id='SqlDatabase' Database='mvdb' Server='MVSQLEXPRESS' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'/> <sql:SqlScript Id="CreateDatabase" ExecuteOnInstall="yes" BinaryKey="CreateDatabaseSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="CreateUsers" ExecuteOnInstall="yes" BinaryKey="CreateUsersSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="CreateBaseLineDb" ExecuteOnInstall="yes" BinaryKey="CreateBaseLineDbSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="RemoveOldGuruContent" ExecuteOnInstall="yes" BinaryKey="RemoveOldGuruContentSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="Upgrade" ExecuteOnInstall="yes" BinaryKey="UpgradeSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="AddCompleteMedia" ExecuteOnInstall="yes" BinaryKey="AddCompleteMediaSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="InstallGuruContent" ExecuteOnInstall="yes" BinaryKey="InstallGuruContentSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="UpdateCustomPlayList" ExecuteOnInstall="yes" BinaryKey="UpdateCustomPlayListSql" SqlDb="SqlDatabase"/> <sql:SqlScript Id="InstallFeaturedContent" ExecuteOnInstall="yes" BinaryKey="InstallFeaturedContentSql" SqlDb="SqlDatabase"/> </Component> <Feature Id="Server" Title="Guru Teach Server" Level="1"> <ComponentRef Id="RegistryEntries"/> <ComponentRef Id='CreateDtxDataUser.exe' /> <ComponentRef Id='Guru.Server.exe' /> <ComponentRef Id='ChangeFirewall' /> <ComponentRef Id='Guru.Server.exe.config' /> <ComponentRef Id='Guru.Server.Remoting.dll' /> <ComponentRef Id='Guru.ServerLibrary.dll' /> <ComponentRef Id='Ionic.Zip.Reduced.dll' /> <ComponentRef Id='JsonChannel.dll' /> <ComponentRef Id='license.dat' /> <ComponentRef Id='Microsoft.Practices.Prism.dll' /> <ComponentRef Id='Microsoft.Practices.ServiceLocation.dll' /> <ComponentRef Id='SQLExpressProvider.dll' /> <ComponentRef Id='Guru_Featured_manifest.xml' /> <ComponentRef Id='GURU_Library_manifest.xml' /> <ComponentRef Id='Guru.Server.Configuration.dll' /> <ComponentRef Id='SqlComponent'/> </Feature> Tanks for the help! Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597489.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ _______________________________________________ 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. ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
