UpgradeDB.exe" -sourceVersion=3 -debug Fails

Question

Attempting to upgrade from 3.1 to 4.0 received this error

A fatal error occurred during the database upgrade.

(#5) Access is denied.

Please run the following at a later date:

"C:\Documents and Settings\Administrator>"C:\Program Files\Sophos\Enterprise Console\UpgradeDB.exe" -sourceVersion=3 -debug

I finished the install and attempted to run the update utility, the results are:

C:\Documents and Settings\Administrator>"C:\Program Files\Sophos\Enterprise Console\UpgradeDB.exe" -sourceVersion=3 -debug
17.06.2010 11:57:15 ... successfully completed.
17.06.2010 11:57:15 Validating parameter values ...
17.06.2010 11:57:15 ... successfully completed.
17.06.2010 11:57:15 Transferring data to SOPHOS4 ...
17.06.2010 11:57:20 Error: DBI exception thrown Cannot open database requested in login 'SOPHOS4'. Login fails.
17.06.2010 11:57:20 Exit code 5 (Failed to transfer data from the old database.)

I dumped the database tables using osql:

C:\Documents and Settings\Administrator>OSQL -E -SWAPBACKUP01\SOPHOS -Q"SELECT name FROM sysdatabases"
name
------------------------------------------------------------------------------- -------------------------------------------------
master
tempdb
model
msdb
SOPHOS3

(5 rows affected)

There is no database named SOPHOS4 which would explain the failure to login error....

How can I correct this???

TIA!

Vince

This thread was automatically locked due to age.

VinceVDC · Accepted Answer

Thanks for the tips!

In the end I extracted the files from the sec_40_sfx.exe file, located the Console installer .msi file, and then extracted the DB directory from it.

In order for the DB creation to complete I had to create the Sophos DB Admin security group.

One the group was created the DB install worked and the upgrade copied the data across.

Thank you for the help!

Vince