Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 9 replies
  • Subscribers 0 subscribers
  • Views 24477 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.
Parents
  • 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
Reply
  • 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
Children
No Data
Unfiltered HTML