In my experience, the user for either SQL Authentication or Windows (Integrated) Authentication, must already be defined on the SQL server. In general, SQL Server won't let a party installing a database from an installer "bootstrap" it's own credentials. -- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com
________________________________________ From: garymonk [g...@gurudental.com] Sent: Tuesday, August 05, 2014 6:25 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Unable to execute sql scripts I changed the util:user to use sa as the user and it worked. So the problem is definitely a permissions issue. The problem is that I have to be able to use Windows authentication. When the database is created the flag is set to create the current user as an administrator (ADDCURRENTUSERASSQLADMIN="True"). Also I can see the current user as an administrator. How do I have WIX create the database using the current user? -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596246.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk _______________________________________________ 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. ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
