Hi Michael, I am actually creating the folder into which I place the .mdf and .ldf files for SQL Server as a part of the install, and those directories are definitely getting created. However, I found a clue on a the following posting:
http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserve r.clustering/2006-10/msg00073.html This basically says you must add disk resources as dependencies for SQL Server or SQL Server cannot see the disks. I am hoping this is the case as it would mean it is not the install, but the configuration of SQL Server that is the issue. Thanks, Amy -----Original Message----- From: Michael Osmond [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2008 3:27 PM To: General discussion for Windows Installer XML toolset.; General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL Server 2008 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 ------------------------------------------------------------------------- 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
