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 actuall creation of the database files is performed as the identity of the service (not the requesting SQL user). Regards Michael ________________________________________ From: kim [contactme...@gmail.com] Sent: Saturday, 12 March 2011 9:09 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database Hello, I am trying to create database and table in SQL Server 2008 using scripts. The script works fine when executed manually in Management studio. But fails with above error "Error 26201. Error -2147467259: failed to create SQL database" when executed from installer. My target machine is Windows XP Professional and database ins SQL Server 2008 R2 Express edition. This same code works on Vista and Windows 7 machines. Following is code from .wxs file Can anyone suggest what am i doing wrong here. Thanks! -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-26201-Error-2147467259-failed-to-create-SQL-database-tp6163225p6163225.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
