Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 3218 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

UpgradeDB.exe" -sourceVersion=3 -debug Fails

VinceVDC

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

:3411


This thread was automatically locked due to age.
Parents
  • 0

    Hi,

    When the database role gets installed, either as part of a full installation or a custom installation where the database component is selected, it should create the directory DB, in the Enterprise Console directory.

    Is the database role going onto a dedicated SQL server?  If so, you need to run the installer on that machine as well as the management server, this will create the SOPHOS4 database.  Just choose custom install and select the database role.  This should then create the SOPHOS4 database.

    If you are installing everything to a single machine, did you choose a custom or full install?  I can only think you must have chosen custom and then not selected the database role?

    That being said, If you have another machine where you can quickly perform a full install (or just the database role if you like, should do it), this should generate you the DB directory, you can then copy this to the other machine and run installDB.bat, the DB directory is self contained.

    I hope this helps.

    jak

    :3416
Reply
  • 0

    Hi,

    When the database role gets installed, either as part of a full installation or a custom installation where the database component is selected, it should create the directory DB, in the Enterprise Console directory.

    Is the database role going onto a dedicated SQL server?  If so, you need to run the installer on that machine as well as the management server, this will create the SOPHOS4 database.  Just choose custom install and select the database role.  This should then create the SOPHOS4 database.

    If you are installing everything to a single machine, did you choose a custom or full install?  I can only think you must have chosen custom and then not selected the database role?

    That being said, If you have another machine where you can quickly perform a full install (or just the database role if you like, should do it), this should generate you the DB directory, you can then copy this to the other machine and run installDB.bat, the DB directory is self contained.

    I hope this helps.

    jak

    :3416
Children
No Data