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

Error while trying to upgrade to EC 4.0/4.5

Harooo,

Having a little trouble while trying to follow the upgrade guide. During the backup process I encounter this :

http://i.imgur.com/Isljx.jpg

The server is a VM on 2003 R2 and running SQL 2005....remote has been enabled...

:5525


This thread was automatically locked due to age.
  • Hi,

    Can you paste the command you ran?

    Are you running BackupDB.bat, if so, with what params?

    Also, does running:

    osql -E -S .\MSSQLSERVER

    connect?

    Thanks

    Jak

    :5526
    • I am following the upgrade advisor guide from sophos...

      It says to navigate to C:\Program Files\Sophos\Enterprise Console\DB

      and run the command

      BackupDB C:\SECBackups\SOPHOS3.bak 

      trying ./MSSQLSERVER returns : Connection string is not valid

      :5527
      • It sounds like you have a custom install, i.e not using a SOPHOS named instance of SQL.

        I would run:

        BackupDB.bat /?

        To see the switches required as you will need to provide more than the default.

        Also, you are backing up a SOPHOS3 database from looking at the command, the subject however is updating EC4 to EC 4.5 so you shouldn't need to do this.  I would suggest calling support so they can check what you have.

        Thanks,

        Jak

        :5528
        • Thanks for the reply...There aren't any switches to modify, I will contact sophos support and see if I can have any luck...

          ps the subject is updating TO EC4/4.5 I should have included from EC3

          Thank you!

          :5530
          • Hello,

            am I right when I assume that SEC3 is working and "just" BackupDB.bat fails? From what you said I'm not sure whether SEC and SQL are on the same server - but you're trying to run the backup on the SQL server.

            Just curious: What's in the registry value HKLM\Software\Sophos\EE\Management Tools\\DatabaseConnectionMS? And what are the contents of the HKLM\Software\Sophos\EE\Management Tools\Database Installer\ and ...\DatabaseUser\ keys?

            Christian

            :5539