[WiX-users] Create MS SQL Server 2008 database during installation.

[Asiri Wanigarathne]

Hi Folks,

I am working on a WIX installer project that requires creating a MS SQL
Server database on SQL Server 2008.

My installer fails with following error message:

Error – 2147467259. Failed to create SQL database.

TestDatabase, error detail: unknown error.

To isolate the issue I created a new project. That only creates the SQL
server database. I found the installer adds a new user to local users with
given user credentials.

Anyone has come across this error before? Any work abounds?

WIX Prooject Source code:

<?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="02d96309-6e59-45a2-9094-9d738fa6bd30" Name="WIX"
Language="1033" Version="1.0.0.0" Manufacturer="WIX"
UpgradeCode="4169c4e0-054c-4166-900a-1c8c30c62175">
        <Package InstallerVersion="200" Compressed="yes" />
        <Media Id="1" Cabinet="media1.cab" EmbedCab="yes" />
    <util:User Id="User"
               Name="TestUser"
               Password="TestPassword"/>
        <Directory Id="TARGETDIR" Name="SourceDir">
            <Directory Id="ProgramFilesFolder">
                <Directory Id="INSTALLLOCATION" Name="WIX">
                     <Component Id="ProductComponent"
Guid="f2c5d3af-bea8-45db-89ca-f9039bcf3af1">
             <CreateFolder />
             <sql:SqlDatabase Id="testDB"
                              ContinueOnError="no"
                              CreateOnInstall="yes"
                              DropOnUninstall="yes"
                              Server="(local)"
                              Instance="MSSQLSERVER"

Database="TestDatabase"
                              User="User"/>
                     </Component>
                </Directory>
            </Directory>
        </Directory>
        <Feature Id="ProductFeature" Title="WIX" Level="1">
             <ComponentRef Id="ProductComponent" />
            <ComponentGroupRef Id="Product.Generated" />
        </Feature>
  </Product>
</Wix>

Thanks,
Regards,
Asiri Wanigarathne
------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users