Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 6 replies
  • Subscribers 1 subscriber
  • Views 3257 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

Issue on Upgrade the SQL server for Enterprise Console 4.0

FGamer

Hello all -

I'm trying to upgrade the SQL server for EC 4.0 and then go to EC 4.5. but I'm getting a error that I dont know how to fix it. The error is when I'm running the EC installer package on my SQL server.

Error msg: Error 2753. The file 'MtInstall.dll.A7BF7F78_EC24_4CF0_9C11_B360F063EAEB' is not marked for installation.

Do you have any clue how can I fix this error?

Thank you

:7619


This thread was automatically locked due to age.
  • 0

    Hi,

    So you're currently running SEC 3 without problems and now you're attempting to run the SEC 4 installer on your SQL server in order to create the new SOPHOS4 database before upgrading the management server to SEC4.  This is what I'll base my suggestion on..

    I would suggest that you could extract the DB directory from the SOPHOS 4 installer and then follow the instructions here:

    http://www.sophos.com/support/knowledgebase/article/110280.html

    To extract the DB directory I would suggest running from a command prompt:

    msiexec /a "Sophos Enterprise Console.msi"

    You can then choose something like "C:\test" as a path, which would result in the DB directory being extracted to:

    "C:\test\program files\Sophos\Enterprise Console\DB"

    to create you a new SOPHOS4 database which is what you need at this point of the install.  this stage will not affect your current running install of SEC3, the task at this point is just to create a new SOPHOS4 database on your SQL server.

    Once done, you can move over to the management server machine and run the SEC 4 installer on that.  As part of that install the command line tool UpdateDB.exe will be called which will move the data from your current SOPHOS3 database to your new SOPHOS4 database.  At which point you are on SEC4.

    You can then follow the same procedure from SEC4 to SEC4.5 or possibly try using the SEC 4.5 installer a go to create the blank SOPHOS45 database, maybe that installer will do better.

    Regards,

    Jak

    :7633
  • 0

    Hello thank you for your help!

    I did this procedure but this procedure fail.

    Look what the log says:

    InstallDB .\sophos swgru1xs03003 SOPHOS4 InstallDB.log

    Started

    01/10/2011

    04:13 PM

    ==========

    Msg 207, Level 16, State 1, Server SWGRU1XS03003\SOPHOS, Procedure From4To45, Line 1483

    Invalid column name 'InstallFirewall'.

    Msg 207, Level 16, State 1, Server SWGRU1XS03003\SOPHOS, Procedure From4To45, Line 1484

    Invalid column name 'InstallSNAC'.

    Msg 207, Level 16, State 1, Server SWGRU1XS03003\SOPHOS, Procedure From4To45, Line 1485

    Invalid column name 'InstallCRT'.

    Can you help me?

    Thx

    :7635
  • 0

    Hi,

    Are you using the SEC4 extracted DB directory?

    I wouldn't have thought the SOPHOS4 database scripts would have a Stored Procedure called From4To45.

    Did you:

    Download:

    sec_40_sfx.exe

    unpack it to:

    C:\sec_402\

    From there run:

    C:\sec_402\ServerInstaller\msiexec /a "Sophos Enterprise Console.msi"

    and choose a path, for example:

    C:\SEC40InstallSet\

    Within that you will find the DB directory from which you can install a SOPHOS4 database.

    InstallDB .\sophos swgru1xs03003 SOPHOS4 InstallDB.log

    Looks the right command if:

    1. Your SQL instance is called SOPHOS.

    2. You are running this command on the SQL server, as the "." represents the local machine.

    3. The SQL server is a member server as I assume swgru1xs03003 is the name of the SQL server

    Rgards,

    Jak

    :7637
  • 0

    Jak -

    I followed your instruction. But my SQL instance is called MSSQLSERVER and when I ran this command: InstallDB .\MSSQLSERVER swgru1xs03003 SOPHOS4 InstallDB.log I got this error:

    [SQL Native Client]SQL Network Interfaces: Connection string is not valid
    [87].
    [SQL Native Client]Login timeout expired
    [SQL Native Client]An error has occurred while establishing a connection to
    the server. When connecting to SQL Server 2005, this failure may be caused by
    the fact that under the default settings SQL Server does not allow remote
    connections.

    [SQL Native Client]SQL Network Interfaces: Connection string is not valid[87].[SQL Native Client]Login timeout expired[SQL Native Client]An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may be caused bythe fact that under the default settings SQL Server does not allow remoteconnections.

    :7679
  • 0

    Jak - as my instance is the default I ran the follow line and works correctly

    InstallDB .\ swgru1xs03003 SOPHOS4 InstallDB.log

    I'll move with the migration and will let you know.

    Thank you!

    :7685
  • 0

    Ahh, ok, in that case you should run:

    InstallDB swgru1xs03003 swgru1xs03003 SOPHOS4 InstallDB.log

    as you can address the instance name with just the machine name.

    The parameters to installdb.bat should be:

    SQLInstance, Domain|MachineName, Database, Logfile

    If you just run the batch file without arguments it will assume:

    machinename\Sophos as the instance.

    MachineName to be %computername%

    Database to be SOPHOS4

    Logfile to be InstallDB.log

    But if you're happy you have the SOPHOS4 database created you should be able to move on.

    Jak

    :7689
Unfiltered HTML