Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 3368 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 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
Reply
  • 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
Children
No Data
Unfiltered HTML