The Sophos Community will be offline for scheduled maintenance this Saturday, May 27th, at 13:00 UTC for approximately 1 hour. Apologies for any inconvenience caused.
"Wanna" ransomware outbreak. Please see this Sophos article sophos.com/kb/126733 for advice on how to protect your organization. Immediate action recommended.
After removing the Sophos database instance and then attempting to re-install Sophos Enterprise Console 4 or Sophos Small Business Console with the database component, the following error message is shown:
Failed to run script: RunAllScripts2Imp: batch file returned error code 1
Once the error is acknowledged the installer rolls back. Checking the InstallDB.log shows the error:
Msg 1802, Level 16, State 4, Server serverName\SOPHOS, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Msg 5170, Level 16, State 1, Server serverName\SOPHOS, Line 1 Cannot create file 'C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\DATA\SOPHOS4.mdf' because it already exists. Change the file path or the file name, and retry the operation.
Note: The error text may be slightly different.
First seen in Sophos Control CenterEnterprise Console
The installer cannot create the files SOPHOS4.mdf and SOPHOS4_log.ldf because they already exist on the system.
1. Confirm the error
First you must confirm that the error shown in the InstallDB.log is as stated above. The instructions given here are only intended for this error.
To find the InstallDB.log file:
2. Re-install the database
Note: If you installed the database to a location other than the default location, you'll need to locate the path to SOPHOS4.mdf and SOPHOS4_ldf for the above procedure.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.