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

Problems with installing Sophos Enterprise Console

I am attempting to upgrade from Sophos 7.6.2 but am having great trouble installing Sophos Endpoint Security and Control 9.5 on a Windows 2003 Server.

This server is NOT connected to the Internet.

I am using the "sec_45_sfx.exe" executable.

The files are unpacked to a "sec_45" folder and a couple of pre-requisites (Windows Installer and Microsoft.NET 3.5 SP1" are installed. A few reboots occur and at this stage all appears to be going well. Then it gets to the bit where it tries to install the Enterprise Console. I have loads of free disk soace so I selected the "Complete Install" option. Then I chose "Enterprise Admins" as the group who could run the Enterprise Console.

A message was displayed saying SQL Server 2008 is being installed but then I got a message saying : "Wizard was interrupted before Sophos Enterprise Console could be completely installed. Your system has not been modified".

I had a quick look around the system and noticed the following :

  • There was a new service called SQLServer(SOPHOS) but it was not started.
  • If you tried to start the SQLServer(SOPHOS) service it fails and a message says "...refer to service-specific error code 1814".
  • The System Event Log has failure events : Source=Service Control Manager, EventID=7024, Desc=Service specific error 1814 (0x716).
  • Under SQL Server Service Manager I have an entry for "<server-name>\SOPHOS" but it has a red square indicationg the database service is stopped.
  • I have a logfile "Program Files\Sophos\EnterpriseConsole\DB\InstallDB.log" but the only things it says in there are
    Install DB <server-name>\SOPHOS ABCD SOPHOS45 InstallDB.log
    Started
    08/06/2011
    10:39
    [DBMSLPCN] SQL Server does not exist or access denied.
    [DBMSLPCN] ConnectionOpen (Connect())
  • My "Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA" folder contains the following items :
    "master.mdf","mastlog.ldf","model.mdf","modellog.ldf","MSDBData.mdf","MSDBLog.ldf".
  • I do NOT have the following items :
    "MS_AgentSigningCertificate.cer", "SOPHOS45.mdf", "SOPHOS45_log.LDF", "tempdb.mdf", "templog.ldf".

If anybody can advise me on how to proceed from here I would be grateful as at the moment I have no anti-virus protection on the network.

There are a few sql scripts that have been put in the "Program Files\Sophos\EnterpriseConsole\DB" folder that look like they might be useful for creating datbases but I do not really know what they do.

I was logged on as a Domain Administrator when I attempted the installation.

Thanks

               Peter

:13849


This thread was automatically locked due to age.
Parents
  • Hello Peter,

    is there a \Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\Log folder with one or more ERRORLOGs in it? These should be the ones of interest. Error 1814 usually indicates a problem with the tempdb (just search "the Internet" for  1814 sql error to get some hints).

    Christian

    :13903
Reply
  • Hello Peter,

    is there a \Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\Log folder with one or more ERRORLOGs in it? These should be the ones of interest. Error 1814 usually indicates a problem with the tempdb (just search "the Internet" for  1814 sql error to get some hints).

    Christian

    :13903
Children
No Data