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

Problems with installing Sophos Enterprise Console

PeterT

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
  • 0

    Hello Christian,

    I found the \Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\Log\ERRORLOG and compared it with another server I have which is working properly.

    The first few lines of my ERRORLOG look pretty much identical. Some version details and registry startup parameters and something about Lock blocks, Node configuration etc.

    There are a couple of lines about "Recovery is writing a checkpoint in database 'master' " and "Recovery completed for database master" which I have got in the working Server's log but do not have in the server that has got problems. I am not sure how significant this is.

    Then there are some lines which definitely look wrong.

    Just after it says :
    Starting up database 'model'
    Informational : No full-text supported languages found
    Starting up database msdb

    I get the following lines :

    Error 17204, Severity 16, State:1

    FCB : Open failed : Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number1. OS error:3 (failed to retrieve text for this error. Reason 1815)

    Error 5120, Severity 16, State : 101

    Unable to open the physical file "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf". Operating system error:3 "3 (failed to retrieve text for this error. Reason : 1815)"

    Error 17204, Severity 16, State:1

    FCB : Open failed : Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number1. OS error:3 (failed to retrieve text for this error. Reason 1815)

    Any idea what that lot means ?

    Peter

    :13919
Reply
  • 0

    Hello Christian,

    I found the \Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\Log\ERRORLOG and compared it with another server I have which is working properly.

    The first few lines of my ERRORLOG look pretty much identical. Some version details and registry startup parameters and something about Lock blocks, Node configuration etc.

    There are a couple of lines about "Recovery is writing a checkpoint in database 'master' " and "Recovery completed for database master" which I have got in the working Server's log but do not have in the server that has got problems. I am not sure how significant this is.

    Then there are some lines which definitely look wrong.

    Just after it says :
    Starting up database 'model'
    Informational : No full-text supported languages found
    Starting up database msdb

    I get the following lines :

    Error 17204, Severity 16, State:1

    FCB : Open failed : Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number1. OS error:3 (failed to retrieve text for this error. Reason 1815)

    Error 5120, Severity 16, State : 101

    Unable to open the physical file "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf". Operating system error:3 "3 (failed to retrieve text for this error. Reason : 1815)"

    Error 17204, Severity 16, State:1

    FCB : Open failed : Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number1. OS error:3 (failed to retrieve text for this error. Reason 1815)

    Any idea what that lot means ?

    Peter

    :13919
Children
No Data