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