Bugs item #1513198, was opened at 2006-06-27 01:56
Message generated for change (Comment added) made by scotk
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: v3.0
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Mike Goatly (mikegoatly)
>Assigned to: Scott Kurtzeborn (scotk)
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>
----------------------------------------------------------------------
>Comment By: Scott Kurtzeborn (scotk)
Date: 2006-12-19 20:42
Message:
Logged In: YES
user_id=1296992
Originator: NO
Please be more specific. In the second scenario you call out WinXP. What
OS was the first scenario on? A different OS?
What tools support ., (local) or localhost? What would this be valid?
Have you tried [ComputerName]?
Because this isn't blocking, we'll address this in WiX v3.
----------------------------------------------------------------------
Comment By: Willem Meints (willemm)
Date: 2006-10-16 12:12
Message:
Logged In: YES
user_id=636503
I get the same problem, while trying to install a database
on the local MSDE installtion with the instance name
configured.
Snippet:
<SqlDatabase Id="ProgramDB" Database="WinkelManagement"
Server="[SQLSERVER]" User="SqlUser"
CreateOnInstall="yes"
DropOnUninstall="no" Instance="[SQLINSTANCE]">
<SqlScript BinaryKey="SqlInstallFile"
Id="InstallationScript"
ExecuteOnInstall="yes"
ContinueOnError="yes"/>
</SqlDatabase>
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=642714&aid=1513198&group_id=105970
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-devs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-devs
