Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 3216 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.
  • 0

    I would run InstallDB.bat as found in the DB directory to create the SOPHOS4 db and then run the previous upgradedb.exe command which will move the data from SOPHOS3 to SOPHOS4.  Once the data is migrated the management service will start.

    Thanks,

    Jak

    :3414
  • 0

    Thanks for the response!

    I don't appear to have that file...

    I've serached for InstallDB.bat file and the DB folder....  I don't appear to have either of them on my system.

    Any other ideas?

    :3415
  • 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
  • 0

    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

    :3439
  • 0

    Hi there...

    I'm running into the same issue.  Also did not originally have the DB folder.

    Trying to upgrade from 3 to 4.

    When I try to run the installdb.bat I get an error that it failed.

    the Installdb.log shows the following:

    [SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance
    Specified [xFFFFFFFF].
    [SQL Native Client]Login timeout expired
    [SQL Native Client]An error has occurred while establishing a connection to
    the server. When connecting to SQL Server 2005, this failure may be caused by
    the fact that under the default settings SQL Server does not allow remote
    connections.

    [SQL Native Client]SQL Network Interfaces: Error Locating Server/InstanceSpecified [xFFFFFFFF].[SQL Native Client]Login timeout expired[SQL Native Client]An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may be caused bythe fact that under the default settings SQL Server does not allow remoteconnections.

    I have checked, remote connections are enabled.

    I have the Sophos DB Admin security group as well.

    Its like I don't have permissions to create SOPHOS4 but I don't understand why...I'm definitely logged in with an administrative account that is a member of the Sophos DB Admin group...

    Thanks for any help.

    :8887