Hello Amy, My suspicion is that the folder structure created by SQL2008 is different to SQL2005 (this was the case between 2000 and 2005). If the folder doesn't exist then the Create Database command will fail. Is there a need to actually set the paths to these folders? If you dont set them then you allow the SQL server to create these files in its own default directories. Then its just a matter of SQL server being correctly configured. Regards Michael
________________________________ From: Amy Rosewater [mailto:[EMAIL PROTECTED] Sent: Tue 23/09/2008 7:13 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] SQL Server 2008 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 ------------------------------------------------------------------------- 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
