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

Enterprise Console. Broken upgrade from 4.0 to 4.5

Hi everyone,

I tried to upgrade our Sophos Enterprise Console from version 4.0 to 4.5.

Server characteristics:

Windows 2008 Standard x64 SP2

SQL Server 2008 x64 Standard fully patched

2 DB instances: SOPHOS4 and SCE2010.

I was logged as a domain administrator. Any server applications was closed. I check if the Sophos Management Service was stopped and it was.

It failed with these errors messages logged in installDB.log:

InstallDB NFBMGM\SOPHOS NFBMGM SOPHOS45 InstallDB.log

Started

Sat 09/18/2010

11:39 AM

==========

Msg 262, Level 14, State 1, Server NFBMGM\SOPHOS, Line 1

CREATE DATABASE permission denied in database 'master'.

Then the installer rolled back the actions.

I tried to reinstall and I have this error message not letting me go further:

sophos update manager must be uninstalled before installing this product

Then Enterprise Console is missing from the Add/Remove programs control panel application...

Does anybody know what to do from now and how can I repair the EC installation?

A support case is already opened...

:5115


This thread was automatically locked due to age.
Parents
  • Hi Jak,

    Thank for the great and detail answer.

    The problem was effectively that the account I used, which is a domain administrator didn't have the proper right on the database. It was because the SQLServer was installed when the server wasn't in the domain.

    I don't know if the Upgrade Advisor check if the account used have the proper rights on the DB...

    When EC 4.5 rolled back the actions, it f*ed all the DB and server. I had to reinstall the server from my image and then the upgrade went well.

    :5132
Reply
  • Hi Jak,

    Thank for the great and detail answer.

    The problem was effectively that the account I used, which is a domain administrator didn't have the proper right on the database. It was because the SQLServer was installed when the server wasn't in the domain.

    I don't know if the Upgrade Advisor check if the account used have the proper rights on the DB...

    When EC 4.5 rolled back the actions, it f*ed all the DB and server. I had to reinstall the server from my image and then the upgrade went well.

    :5132
Children
No Data