Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 2280 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

SQL not supported - update from Ent Console 3.1.0.2476 to 4.5

mtq

Hi,

I am attempting to upgrade Enterprise Console from 3.1.0.2476 to 4.5. I have visied http://sophos.com/support./upgrades, downloaded the advisor and it tells me

Warning SQL server compatibility,The SQL server used is no longer supported. The upgrade will involve upgrading the SQL server.

So, I upgraded to SQLExpress 2008R2, re-ran the advisor and got the same message.

Any ideas?

Regards

Scott

:5913


This thread was automatically locked due to age.
  • 0

    Hello Scott,

    are you running SEC3.1 with the upgraded SQL server? Please check the version manually.

    sqlcmd -E -S <server\instance> -W -Q "SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')"
     where <server\instance> should be taken from the registry value DatabaseConnectionMS under HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\ (Data Source=..., and Initial Catalog= should be SOPHOS3 in your case).

    Christian

    :5921
  • 0

    Thanks Christian,

    the output of your command using SOPHOS as the instance

    8.00.760 SP3 Desktop Engine

    and sqlcmd -L list SQLEXPRESS and SOPHOS as the only instances on this server

    The registry entry is

    Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS3;Data Source=MTQIS01\SOPHOS;

    Regards

    Scott

    :5932
  • 0

    Is R2 supported with SEC 4.5?  

    I'm sure it'll work but I don't think it's supported until 4.7.  

    Jak

    :5933
  • 0

    Thanks Jak,

    the upgrade advisor mentions

    Notes about system requirements

    Enterprise Console 4.5 requires:

    • SQL Server 2005 (Express) or higher
    • Windows Server 2003 or higher*

    I assumed that 2008Express R2 was just a newer version and as such qualified under the "or higher" part of the system requirements.

    Scott

    :5935