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
