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

Upgrade from SEC 4.7 to SEC 50

BudgetHelp

Hi - I need to know how to upgrade SEC 4.7 to 50 but more so on the database side

We have the following set up:

Windows_ServerA running SEC4.7 and Update Mgr

Windows_ServerB running SQL 2008 Server with SOPHOS47 database

I can upgrade the SEC console no problem, but need advise on how to upgrade the SOPHOS47 DB to SOPHOS50 ?

On the SEC server to talk to the remote database, we modified this key:

Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS47;Data Source=<serverB>;

:19561


This thread was automatically locked due to age.
Parents
  • 0

    Can you just put the name of the SQL server in the box?  If you're using the default (no-named instance) that should do it.  

    Otherwise:

    (local)

    or

    .

    should also work,

    If it all fails and you still have no joy, it is possible just to run the batch files from the DB directories (core and patch) to install the databases, but best to use the installer to minimise errors if you can.  You already have the "Sophos DB Admins" group, and the "DB account" the management service is using to connect to the database will still be a member of that.

    Jak

    :19605
Reply
  • 0

    Can you just put the name of the SQL server in the box?  If you're using the default (no-named instance) that should do it.  

    Otherwise:

    (local)

    or

    .

    should also work,

    If it all fails and you still have no joy, it is possible just to run the batch files from the DB directories (core and patch) to install the databases, but best to use the installer to minimise errors if you can.  You already have the "Sophos DB Admins" group, and the "DB account" the management service is using to connect to the database will still be a member of that.

    Jak

    :19605
Children
No Data