Bugs item #1513198, was opened at 2006-06-27 08:56
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=642714&aid=1513198&group_id=105970
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: documentation
Group: v2.0
Status: Open
Resolution: None
Priority: 5
Submitted By: Mike Goatly (mikegoatly)
Assigned to: Nobody/Anonymous (nobody)
Summary: SqlDatabase default server not working
Initial Comment:
When using ., (local) or localhost as the server name
in the SqlDatabase element, the generated MSI hangs
for a while while installing (it looks like a SQL
connect timeout) and then reports:
Error -2147467259: failed to create SQL database:x,
error default: unknown error.
If you explicitly set the server name, the database
is correctly created.
Note that I also tested this on a WinXP box with a
named SQL Server instance, and using . or (local) as
the server name with the instance name specified
worked fine.
Here's a snippet of code that I use:
<Directory Id='TARGETDIR' Name='SourceDir'>
<Component Id='ClientDatabase' Guid='xxxxxxxx-
xxxx-xxxx-xxxx-xxxxxxxxxxxx' DiskId='1'>
<SqlDatabase
Id='ClientDatabase'
Database='[DATABASENAME]'
Server='[SQLSERVER]'
Instance='[SQLINSTANCE]'
CreateOnInstall='yes'
ConfirmOverwrite='yes' >
<SqlScript
Id='ExecuteStructureSql' ExecuteOnInstall='yes'
BinaryKey='StructureSql' Sequence='1' />
<SqlScript
Id='ExecuteGeneratedSql' ExecuteOnInstall='yes'
BinaryKey='GeneratedSql' Sequence='2' />
</SqlDatabase>
</Component>
</Directory>
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=642714&aid=1513198&group_id=105970
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
WiX-devs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-devs
