Hi All,
I have an install that has been working well for months against SQL
Server 2005. We recently upgraded one of our test servers to SQL Server
2008 and now the Wix Component to create my database no longer executes
correctly.
The error number I receive is 26201. I have searched for other reports
of this error being encountered and it appears to potentially be related
to the use of the SqlFileSpec and SqlLogFileSpec elements in my wix xml.
>From my log:
Error 26201. Error -2147217900: failed to create SQL database:
iVantage50, error detail: CREATE DATABASE failed. Some file names listed
could not be created. Check related errors..
>From my wix xml:
<sql:SqlDatabase Id="IVantageDatabase" Server="[SQLSERVER]"
Database="[DATABASENAME]" User="InstallationSqlUser"
CreateOnInstall="yes" DropOnUninstall="yes">
<sql:SqlFileSpec Id="IVantageDatabaseFile"
Filename="[DataDirectory][DATABASENAME][DATABASEFILEEXT]"
Name="[DATABASENAME]" />
<sql:SqlLogFileSpec Id="IVantageDatabaseLogFile"
Filename="[DataDirectory][DATABASENAME][DATABASELOGFILENAMEEXT][DATABASE
LOGFILEEXT]" Name="[DATABASENAME][DATABASELOGFILENAMEEXT]" />
Any ideas why this would stop working for SQL Server 2008?
Thanks in advance for your help.
Amy Rosewater
SPECTRUM Human Resource Systems Corporation
707 17th Street Suite 3800
Denver CO, 80202
303.592.3403
[EMAIL PROTECTED]
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
