Do the files you're trying to create in your command already exist on this PC? That would make the create database command fail.
Or are you saying that even on the same PC, the same command with the same paths works in SSMS but fails in your MSI? Forgive me if you've already covered this. -----Original Message----- From: kim [mailto:contactme...@gmail.com] Sent: 17 March 2011 21:59 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to createSQL database Mike, My SQL script is not having GO command after each sql statement. The reason being the sql scripts works perfect when executed manually in Management studio. If nothing works then I have to create database from within sql script "Create database...." tag is simply not working in this scenario! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-2620 1-Error-2147467259-failed-to-create-SQL-database-tp6163225p6182677.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------ ------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users