...also if you switch the account initially specified for services to run under during setup of sql05 or sql08 to a different account sometime after setup completes you need to remember to add that account to the appropriate SqlServer<Version><Service><Instance> local security groups in order for the necessary security permissions to be present.
-----Original Message----- From: Neil Sleightholm [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2008 10:01 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL Server 2008 Amy SQL 2005 runs as "Network Service" as well so you should have seen the problem there. You shouldn't need to make it run as "Local System" (in fact it opens a security issue) as the SQL install sets the permissions on the data and log folders (it is group SQLServerxxxxx). If you are installing to a non-default folder then you would need to change the permissions on that folder. I did come across a PC that had a permissions problem but that was due to the way another instance of SQL had been installed by the PC manufacturer. I hope this helps. Neil -----Original Message----- From: Amy Rosewater [mailto:[EMAIL PROTECTED] Sent: 23 September 2008 17:45 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL Server 2008 Hi All, This did indeed turn out to be a SQL Server 2008 configuration issue related to the identity under which the SQL Server service was running. Once this was set to Local System (which has permissions to write to the Program Files directory) it works fine. Just in case anyone else runs into this one. Amy -----Original Message----- From: Amy Rosewater [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2008 4:19 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL Server 2008 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 ------------------------------------------------------------------------ - 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
