Kim I can't see anything wrong with the script. But the error seems to be specifically with the creation of the database itself from the error.
Things you could try: 1. Check that your account actually is an administrator in SQL Server. I have not had much experience with Express, but in a default SQL 2008 Server install the administrator of the windows environment is not automatically an administrator in SQL Server (unlike earlier versions). 2. Do you have access to SQL Profiler (I don't think its part of express) you can run a trace while the install is happening it may give you more insight into what is happening 3. Check the SQL Server Logs - access is via the management studio. 4. Use SQLCMD, rather than studio, and run create database XXX and see what happens (use the -E option so that you are using the same authentication as you would with the MSI. Hope these help Michael -----Original Message----- From: kim [mailto:contactme...@gmail.com] Sent: Friday, 18 March 2011 6:27 AM 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 ------------------------------------------------------------------------------ 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
