Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 0 subscribers
  • Views 24473 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

SEC 5.2 and SQL SERVER 2008 R2

donkers

Dear all,

I have SEC 5.0.0.8 installed with SQL 2008 R2 SP2 as the back-end. 

When I attempt to upgrade the database, I get "The version of SQL Server instance ... is not supported" in the UI; "The version of the sql instance selected is not valid" in the bootstrapper log.  SQL 2008 support is available on the system requirements page, but I notice there's no mention of SQL 2008 R2.  It must have worked at some point, because I'm using SQL 2008 R2 right now with SEC 5.0.0.8...

Is it possible to upgrade the database with this version of SQL, or do I need to create an instance of SQL 2008 Express?

many thanks!

:52106


This thread was automatically locked due to age.
  • 0

    Hi,

    That version of SQL should be fine for all current version of SEC.

    I know that the installer connects to the instance and runs the stored procedure

    sp_server_info

    Looking for the SYS_SPROC_VERSION attribute.

    As long as the major version is greater to equal to 9 it's valid (MSDE and SQL 2000 have version less than 9, which is what it's looking for.

    So I would expecute sp_server_info as the same account you're running the SEC installer as to see what value you get back for the SYS_SPROC_VERSION attribute.  If you don't have SQL Server Management Studio handy you could run:

    sqlcmd -E -S .\sophos -Q "sp_server_info" | find "SYS_SPROC_VERSION"

    Mine reports as 10.50.2500, which according to http://sqlserverbuilds.blogspot.co.uk/ is SQL 2008 R2 which is what I'm running and the same version as listed in SQL Management Studio next to the instance name at the top of the tree.

    Hope this helps.

    Regards,

    Jak

    :52108
  • 0

    My SYS_SPROC_VERSION is 10.50.4000.  The difference is that you're on SP1, I'm on SP2.

    This is a named SQL instance "MSSQLSERVER2008".  The dropdown to choose the SQL instance has only one entry, "MSSQLSERVER2008". 

    However, the default SQL instance on the server is SQL 2000.  Could the installer be checking the wrong instance?

    Muchly appreciate your help Jak!

    -ben

    :52114
  • 0

    Hello ben,

    the workflow of the GUI and details of the failed check should be in the bootstrapper log (in %ProgramData%\Sophos\Management Installer\). Maybe this gives some insight.

    Christian

    :52116
  • 0

    Thanks Christian; unfortunately bootstrapper log is no more elucidatory.

    23/07/2014 5:00:59 PM, INFO : Validating whether logged on user can access the selected sql instance...
    23/07/2014 5:00:59 PM, INFO : Connection to database succeeded
    23/07/2014 5:00:59 PM, INFO : Validating selected SQL instance version...
    23/07/2014 5:00:59 PM, ERROR : The version of the sql instance selected is not valid

    :52148
  • 0

    Maybe it would be worth downloading 5.2.1 R2 from the legacy downloads page to see if you get different results.

    I see from the 5.2.2 release notes:

    http://downloads.sophos.com/readmes/sec_522_rneng.html

    It has the item:

    • (DEF95350) When modifying a SEC 5.2.1 R2 installation, the installer rediscovers SQL Server instance, rather than using an already configured database instance.

    I wonder if there is a problem in this area due to this change.

    Attempting 5.2.1 R2 would rule that out and you're only testing the bootstrapper anyway so you could cancel out of it without modification.

    Regards,

    Jak

    :52150
  • 0

    Sounded promising!  Unfortunately no dice; just tried 5.2.1 R2 and got the same behaviour.

    :52152
  • 0

    Hello ben,

    the bootstrapper log mentions database and instance in a few messages before it gets to the Validating stage. One of these (or one nearby) might at least indicate what caused the bootstrapper to ask for the instance. Otherwise I've run out of ideas and it'd be time for giving Support a call. 

    Christian

    :52162
  • 0

    Thanks Christian.  I will contact support.

    Full bootstrapper here FYI:

    29/07/2014 1:32:37 PM, INFO : Detected MSI version: 4.5.6001
    29/07/2014 1:32:37 PM, INFO : Activate state: Idle
    29/07/2014 1:32:37 PM, INFO : Obtaining SQL instances on local machine...
    29/07/2014 1:32:38 PM, INFO : Computer is joined to domain: MYDOMAINNAME
    29/07/2014 1:32:38 PM, INFO : Found MSI: \Console32.msi version: 5.2.2
    29/07/2014 1:32:38 PM, INFO : Found MSI: \Server32.msi version: 5.2.2
    29/07/2014 1:32:39 PM, INFO : Found MSI: \Database32.msi version: 5.2.2
    29/07/2014 1:32:39 PM, INFO : Finished retrieving instances - Timeout
    29/07/2014 1:32:39 PM, INFO : Initialized COM in the SQL server searcher thread
    29/07/2014 1:32:39 PM, INFO : Obtaining remote SQL instances on network...
    29/07/2014 1:32:39 PM, INFO : Validating whether logged on user can access the selected sql instance...
    29/07/2014 1:32:39 PM, INFO : Found MSI: SUM.msi version: 1.5.2.1060
    29/07/2014 1:32:39 PM, INFO : Clean workflow
    29/07/2014 1:32:40 PM, INFO : Changed installation value: SERVER_PORT="80"
    29/07/2014 1:32:40 PM, INFO : Changed installation value: SERVER_FEEDBACKENABLED="1"
    29/07/2014 1:32:40 PM, INFO : Entered Welcome page.
    29/07/2014 1:32:40 PM, INFO : Finished retrieving instances - Timeout
    29/07/2014 1:32:41 PM, INFO : Running System Property Check: User must be an administrator on this computer...
    29/07/2014 1:32:41 PM, INFO : System Property Check: User must be an administrator on this computer - PASSED
    29/07/2014 1:32:41 PM, INFO : Running System Property Check: OS version must be Windows XP, Windows 2003 or later...
    29/07/2014 1:32:41 PM, INFO : System Property Check: OS version must be Windows XP, Windows 2003 or later - PASSED
    29/07/2014 1:32:41 PM, INFO : Running System Property Check: All SEC components installed must be the same version...
    29/07/2014 1:32:41 PM, INFO : Found MSI: \Console32.msi version: 5.2.2
    29/07/2014 1:32:41 PM, INFO : Found MSI: \Server32.msi version: 5.2.2
    29/07/2014 1:32:41 PM, INFO : Found MSI: \Database32.msi version: 5.2.2
    29/07/2014 1:32:41 PM, INFO : Found MSI: SUM.msi version: 1.5.2.1060
    29/07/2014 1:32:41 PM, INFO : System Property Check: All SEC components installed must be the same version - PASSED
    29/07/2014 1:32:42 PM, INFO : Entered Eula page.
    29/07/2014 1:32:43 PM, INFO : Accepted Eula.
    29/07/2014 1:32:44 PM, INFO : Entered Custom Setup page
    29/07/2014 1:32:47 PM, INFO : Selected DATABASE installation
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: User must be an administrator on this computer...
    29/07/2014 1:32:47 PM, INFO : System Property Check: User must be an administrator on this computer - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: OS version must be Windows XP, Windows 2003 or later...
    29/07/2014 1:32:47 PM, INFO : System Property Check: OS version must be Windows XP, Windows 2003 or later - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: All SEC components installed must be the same version...
    29/07/2014 1:32:47 PM, INFO : Found MSI: \Console32.msi version: 5.2.2
    29/07/2014 1:32:47 PM, INFO : Found MSI: \Server32.msi version: 5.2.2
    29/07/2014 1:32:47 PM, INFO : Found MSI: \Database32.msi version: 5.2.2
    29/07/2014 1:32:47 PM, INFO : Found MSI: SUM.msi version: 1.5.2.1060
    29/07/2014 1:32:47 PM, INFO : System Property Check: All SEC components installed must be the same version - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Machine name should not exceed 15 characters...
    29/07/2014 1:32:47 PM, INFO : System Property Check: Machine name should not exceed 15 characters - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: SEC 1.x, 2.0 or 3.x must not be installed on this computer...
    29/07/2014 1:32:47 PM, INFO : SEC 2.x is not installed on local system. MsiQueryProductState return -1
    29/07/2014 1:32:47 PM, INFO : SEC 3.x is not installed on local system. MsiQueryProductState return -1
    29/07/2014 1:32:47 PM, INFO : System Property Check: SEC 1.x, 2.0 or 3.x must not be installed on this computer - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Sophos Help Desk must not be installed on this computer...
    29/07/2014 1:32:47 PM, INFO : System Property Check: Sophos Help Desk must not be installed on this computer - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Sophos Control Center 2.x must not be installed on this computer...
    29/07/2014 1:32:47 PM, INFO : System Property Check: Sophos Control Center 2.x must not be installed on this computer - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Simple file sharing must be disabled...
    29/07/2014 1:32:47 PM, INFO : System Property Check: Simple file sharing must be disabled - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: SQL browser service should be running...
    29/07/2014 1:32:47 PM, INFO : Initializing the service: SQLBrowser
    29/07/2014 1:32:47 PM, INFO : System Property Check: SQL browser service should be running - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Sophos EM Console must not be installed on this computer...
    29/07/2014 1:32:47 PM, INFO : System Property Check: Sophos EM Console must not be installed on this computer - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Support operating system version and service pack must be installed...
    29/07/2014 1:32:47 PM, INFO : Version: 5.2.3790 SP: 2 Architecture: 1 Suitemask: 272
    29/07/2014 1:32:47 PM, INFO : OS version 5.2 Service pack installed
    29/07/2014 1:32:47 PM, INFO : System Property Check: Support operating system version and service pack must be installed - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: This computer should have at least 5GB free disk space on the primary drive...
    29/07/2014 1:32:47 PM, INFO : Enough space: 20635.000000 Mb
    29/07/2014 1:32:47 PM, INFO : System Property Check: This computer should have at least 5GB free disk space on the primary drive - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: Sophos Client Firewall should not be installed on a remote database...
    29/07/2014 1:32:47 PM, INFO : About to establish interface to Sophos Client Firewall
    29/07/2014 1:32:47 PM, INFO : Unable to establish interface with Sophos Client Firewall. Return value: 0x80040154
    29/07/2014 1:32:47 PM, INFO : System Property Check: Sophos Client Firewall should not be installed on a remote database - PASSED
    29/07/2014 1:32:47 PM, INFO : Running System Property Check: SEC should not be installed on a Domain Controller...
    29/07/2014 1:32:47 PM, INFO : The computer is not a Domain Controller
    29/07/2014 1:32:47 PM, INFO : System Property Check: SEC should not be installed on a Domain Controller - PASSED
    29/07/2014 1:32:48 PM, INFO : Entered Destination page.
    29/07/2014 1:32:48 PM, INFO : Changed installation value: INSTALLDIR="C:\Program Files\Sophos"
    29/07/2014 1:32:56 PM, INFO : There is not a SOPHOS instance on the local machine
    29/07/2014 1:32:56 PM, INFO : Uninitialized COM in SQL server searcher thread
    29/07/2014 1:32:56 PM, INFO : Entered Database page.
    29/07/2014 1:32:56 PM, INFO : Found SqlExpress pre-req executable in the location: S:\ServerInstaller\pre-reqs\sqlExpress2008R2SP1\SQLEXPR32_x86_ENU.exe
    29/07/2014 1:33:11 PM, INFO : Checking whether account: MYDOMAINNAME\administrator is local...
    29/07/2014 1:33:11 PM, INFO : It is a domain account
    29/07/2014 1:33:13 PM, INFO : Validating account retrived by Object picker...
    29/07/2014 1:33:13 PM, INFO : Validating the user account...
    29/07/2014 1:33:13 PM, INFO : The specified account is not disabled and has a password that never expires.
    29/07/2014 1:33:14 PM, INFO : Validating whether logged on user can access the selected sql instance...
    29/07/2014 1:33:14 PM, INFO : Connection to database succeeded
    29/07/2014 1:33:14 PM, INFO : Validating selected SQL instance version...
    29/07/2014 1:33:14 PM, ERROR : The version of the sql instance selected is not valid

    :52251
  • 0

    Thanks everyone for your help. 

    Sophos Support suggested a manual upgrade of the database, and that solved my problems.  The procedure article for this is listed here in case anyone else runs into a similar problem... :)

    -----------------------------------------
    Article ID:116768
    Title:Manually creating the Sophos databases for Enterprise Console as part of an install or upgrade
    URL: https://sophos.com/kb/116768
    -----------------------------------------

    :52433
Unfiltered HTML