Hi Rob My experience Error 0x80004005 will be an access denied type error. Check the SQL Management Logs for the SQL instance to see what the error is. Possible issues:
* It could be logon (description below on how to diagnose a logon error) * It could be be privilege. * It could be you are setting a path to the MDF / LDF files that the SQL Service does not have access to. To check the 2nd and 3rd errors, run the equivalent create database command from a remote tool, using the appropriate logon and see what error you get Logon Error: If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage. To determine the true reason for the failure, the administrator can look in the server's error log where a corresponding entry will be written. An example of an entry is: 2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8. 2006-02-27 00:02:00.34 Logon Login failed for user '<user name>'. [CLIENT: <ip address>] The key to the message is the 'State' which the server will accurately set to reflect the source of the problem. In the example above, State 8 indicates that the authentication failed because the user provided an incorrect password. The common error states and their descriptions are provided in the following table: ERROR STATE ERROR DESCRIPTION 2 and 5 Invalid userid 6 Attempt to use a Windows login name with SQL Authentication 7 Login disabled and password mismatch 8 Password mismatch 9 Invalid password 11 and 12 Valid login but server access failure 13 SQL Server service paused 18 Change password required State 16 = Does not have access to database. Regards Michael -----Original Message----- From: Rob Harrison [mailto:rharri...@volumatic.com] Sent: Monday, 12 September 2011 8:28 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Wix CreateDatabase failure to connect to remote SQL Server Express 2005 Hi, Using the Wix 3.5 release, the attached Wix project fails to create a database on the remote SQL Server Express 2005 machine using SQL authentication. The following error is reported in the MSI log snippet: ------ MSI log ---------------------------------------------------- MSI (s) (E8:08) [11:03:50:456]: Executing op: ActionStart(Name=CreateDatabase,Description=Creating Databases,) MSI (s) (E8:08) [11:03:50:456]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=Binar yData,Target=**********,CustomActionData=**********) MSI (s) (E8:58) [11:03:50:467]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI395.tmp, Entrypoint: CreateDatabase CreateDatabase: Error 0x80004005: failed to create to database: 'TestDb', error: unknown error Error 26201. Error -2147467259: failed to create SQL database: TestDb, error detail: unknown error. MSI (s) (E8:58) [11:04:09:043]: Product: TestCreateDb -- Error 26201. Error -2147467259: failed to create SQL database: TestDb, error detail: unknown error. Action ended 11:04:09: InstallFinalize. Return value 3. ------ MSI log ---------------------------------------------------- My remote server (named Win7-64) is a Windows 7 64-bit machine with SQL server installed and configured to allow remote access via port TCP/IP 1433. I can connect to SQL Server and create the database remotely using other mechanisms including Management Studio Express and a native C++ test project using SQL Native Client ADO. I've even managed to embed a custom Vbscript action into the Wix script that will create the database remotely via ADO using Sql Auth, however it seems more correct to use the in-built SqlDatabase Wix elements. Can anyone help? Suggestions appreciated, Rob. ------- Product.wxs ------------------------------------------------ <?xml version="1.0" encoding="UTF-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension"; xmlns:util="http://schemas.microsoft.com/wix/UtilExtension";> <Product Id="d7acc7da-b4d7-4678-8381-27c798d6b8fd" Name="TestCreateDb" Language="1033" Version="1.0.0.0" Manufacturer="TestCreateDb" UpgradeCode="1aff6a39-41bc-4d67-ae36-faf528bd8b7b"> <Package InstallerVersion="300" Compressed="yes" /> <Media Id="1" Cabinet="media1.cab" EmbedCab="yes" /> <util:User Id="SqlUser" Name="sa" Password="some-password" /> <Directory Id="TARGETDIR" Name="SourceDir"> <Directory Id="ProgramFilesFolder"> <Directory Id="INSTALLLOCATION" Name="TestCreateDb"> <Component Id="TestDbCreate" Guid="D94463D3-4220-4037-8E6C-78572741A247"> <File Id="FileTxt" Source="file.txt" /> <sql:SqlDatabase Id="TestDb" Database="TestDb" User="SqlUser" Server="Win7-64" CreateOnInstall="yes" DropOnUninstall="yes"> </sql:SqlDatabase> </Component> </Directory> </Directory> </Directory> <Feature Id="ProductFeature" Title="TestCreateDb" Level="1"> <ComponentRef Id="TestDbCreate" /> </Feature> </Product> </Wix> ------- Product.wxs ------------------------------------------------ ******************************************************** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version. ******************************************************** ------------------------------------------------------------------------------ Doing More with Less: The Next Generation Virtual Desktop What are the key obstacles that have prevented many mid-market businesses from deploying virtual desktops? How do next-generation virtual desktops provide companies an easier-to-deploy, easier-to-manage and more affordable virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerry® mobile platform with sessions, labs & more. See new tools and technologies. Register for BlackBerry® DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
