Kim General guidance. Are you setting the file path for the MDF and LDF files of the database in the WIX code? I can't see this in the emails I get.
If so the Account that the SQL Server service logs on as, will need to have write / modify access to the folders in the paths you specify. In your case that means NETWORK SERVICE. Check in the Security Tab for the folder in question. Network Service has no special file system rights above BuiltIn\Users by default. An alternative (especially if you are deploying to aN SQL Server that is being properly managed by a DBA) is don't specify to MDF or LDF files at all. This allows the SQL Server to create these files in its default locations. If the server is being properly managed these will be set appropriately. Michael -----Original Message----- From: kim [mailto:contactme...@gmail.com] Sent: Wednesday, 16 March 2011 1:32 AM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Error 26201. Error -2147467259: failed to create SQL database Michael, Can you please guide me on how should I check the file permissions for SQL Server? While installing SQL Express I did used NT AUTHORITY\NETWORK SERVICE account. 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-tp6163225p6173206.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
