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.
