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

Remote SQL Server and 4.0 -> 4.5 Console Upgrade

Dean_F
Ok, so I ran the upgrade adviser tool and it flagged my current 4.0 system because I have a remote SQL server. I get the warning, "Non-Sophos databases have been added to the SOPHOS instance. Applications relying on these databases may stop working after the upgrade." Of course there are other databases, it's an SQL Server. Will this warning affect me and will my other DB's really encounter problems if I were to continue? I had a heck of a time getting the 4.0 db to load on a real SQL Server.
:3920


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

    You should be glad it warns as it beats banging your head against a wall when you don't have a backup of the other databases or the installer has pushed the MSDE instance to SQL 2008 and the other application sharing the instance breaks as this isn't supported by them.

    The following KBA says why the Upgrade Advisor warns of this issue. 

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

    IMPORTANT: In these messages, the term "SOPHOS" is in fact referring to the instance name where the SOPHOS4 database is located.
    Sophos recommends that you backup databases before making any changes to your system.
    Any work performed on the SOPHOS SQL instance has the potential to affect another applications that are using the SOPHOS instance. 
    For instance, if your SOPHOS instance is in MSDE format, this instance will be upgraded to SQL Server Express 2008 during the upgrade. We cannot guarantee that your other applications will be unaffected by this upgrade, so we urge you to check with the other software applications' vendors before proceeding.
    If you are required to use a single SQL instance to host all of your databases, it is advisable to use an instance name other than SOPHOS so assumptions are not made by the installer.

    IMPORTANT: In these messages, the term "SOPHOS" is in fact referring to the instance name where the SOPHOS4 database is located.
    Sophos recommends that you backup databases before making any changes to your system.
    Any work performed on the SOPHOS SQL instance has the potential to affect another applications that are using the SOPHOS instance. For instance, if your SOPHOS instance is in MSDE format, this instance will be upgraded to SQL Server Express 2008 during the upgrade. We cannot guarantee that your other applications will be unaffected by this upgrade, so we urge you to check with the other software applications' vendors before proceeding.
    If you are required to use a single SQL instance to host all of your databases, it is advisable to use an instance name other than SOPHOS so assumptions are not made by the installer.

    :3945

     - - - - - - - - - - - -

    Communities Moderator, SOPHOS
    Knowledge Base  |  @SophosSupport  |  Video tutorials
    Remember to like a post.  If a post (on a question thread) solves your question use the 'This helped me' link.

Reply
  • 0

    You should be glad it warns as it beats banging your head against a wall when you don't have a backup of the other databases or the installer has pushed the MSDE instance to SQL 2008 and the other application sharing the instance breaks as this isn't supported by them.

    The following KBA says why the Upgrade Advisor warns of this issue. 

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

    IMPORTANT: In these messages, the term "SOPHOS" is in fact referring to the instance name where the SOPHOS4 database is located.
    Sophos recommends that you backup databases before making any changes to your system.
    Any work performed on the SOPHOS SQL instance has the potential to affect another applications that are using the SOPHOS instance. 
    For instance, if your SOPHOS instance is in MSDE format, this instance will be upgraded to SQL Server Express 2008 during the upgrade. We cannot guarantee that your other applications will be unaffected by this upgrade, so we urge you to check with the other software applications' vendors before proceeding.
    If you are required to use a single SQL instance to host all of your databases, it is advisable to use an instance name other than SOPHOS so assumptions are not made by the installer.

    IMPORTANT: In these messages, the term "SOPHOS" is in fact referring to the instance name where the SOPHOS4 database is located.
    Sophos recommends that you backup databases before making any changes to your system.
    Any work performed on the SOPHOS SQL instance has the potential to affect another applications that are using the SOPHOS instance. For instance, if your SOPHOS instance is in MSDE format, this instance will be upgraded to SQL Server Express 2008 during the upgrade. We cannot guarantee that your other applications will be unaffected by this upgrade, so we urge you to check with the other software applications' vendors before proceeding.
    If you are required to use a single SQL instance to host all of your databases, it is advisable to use an instance name other than SOPHOS so assumptions are not made by the installer.

    :3945

     - - - - - - - - - - - -

    Communities Moderator, SOPHOS
    Knowledge Base  |  @SophosSupport  |  Video tutorials
    Remember to like a post.  If a post (on a question thread) solves your question use the 'This helped me' link.

Children
No Data
Unfiltered HTML