Hi Chintana Make sure it is not read only. I was able to run setup actions multiple times with no problems.
Also make sure you have the latest setupactions with the patch. If you need to delete the MDF and run again. Regards, Drew ________________________________________ From: Chintana Wilamuna [[email protected]] Sent: Thursday, April 16, 2009 10:08 PM To: [email protected] Subject: Error when running SetupActions.exe Hi, When running SetupActions.exe I'm getting and error and after stepping through the debugger, it says, MSG_DBFAIL CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\StockTraderDB.mdf' because it already exists. Change the file path or the file name, and retry the operation. At first go, I forgot to enable mixed mode auth in SQL Server and ran SetupActions.exe. After that when I try to run it again I'm seeing the above error message. Is it that SQL Server create the databases on disk first and then try to create them on the database? If this is the case, it explains why the if exists drop database clause has no effect at all. So, should I be just deleting the mdf file and run SetupActions.exe again? Bye, -Chintana -- http://engwar.com/
