The scenario isn't clear to me at all. If this is a custom action it'll be running with the installing user's account or the system account. Exactly what is the environment here that leads you to say that "Network Service account was not having full control permission on C:\Program Files\Microsoft SQL Server folder and subfolders where is the default path to create database". How is the Network service account related to this?
Phil Wilson -----Original Message----- From: kim [mailto:contactme...@gmail.com] Sent: Thursday, March 17, 2011 1:27 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database Thanks for reply Mike. Yes I am using Windows Authentication to connect to database. However when installing SQL Server 2008 Express edition I selected Mixed mode. I am attaching my code here (since due to some wierd error my code is not visible in post) http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n6182398/CreateDatabaseScript.txt CreateDatabaseScript.txt Please let me know if you find anything incorrect 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-tp6163225p6182398.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 *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. This email comes from a division of the Invensys Group, owned by Invensys plc, which is a company registered in England and Wales with its registered office at 3rd Floor, 40 Grosvenor Place, London, SW1X 7AW (Registered number 166023). For a list of European legal entities within the Invensys Group, please go to http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77. You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail recept...@invensys.com. This e-mail and any attachments thereto may be subject to the terms of any agreements between Invensys (and/or its subsidiaries and affiliates) and the recipient (and/or its subsidiaries and affiliates). ------------------------------------------------------------------------------ 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