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

Dabase mirror issues Enterprise 4.5

Wally

I am currently setting up DRP hot site for my servers.

I have mirrored the Sophos SQL2005 database  to a server at the DRPsite.

SQL Server1 = Original site

SQL Server 2 = DRP site

When I failover Server 1 to server 2 , the management console will not work.

How do I tell the management console that if SQL server 1 is down, then just go to SQL server 2.

Is it configured in the registry?

Enterprise 4.5

SQL 2005

:21569


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

    HI,

    I don't think is is supported, Sophos supports a clustered SQL instance but it is a 1-1 mapping between management service and database instance.  

    Having said that, you could try setting the "Failover Partner " option in the connection string, i.e. in: 

    HKEY_LOCAL_MACHINE\SOFTWARE\[Wow6432Node]\Sophos\EE\Management Tools \DatabaseConnectionMS

    but I've not tried

    If there is a replica of a SOPHOS45 database and you update the connection string and the account the management service is connecting to the database has the necessary rights (should get these by being a member of the "Sophos DB Admins" windows group) you should be able to point the management service at any database.

    Regards,

    Jak

    :21579
Reply
  • 0

    HI,

    I don't think is is supported, Sophos supports a clustered SQL instance but it is a 1-1 mapping between management service and database instance.  

    Having said that, you could try setting the "Failover Partner " option in the connection string, i.e. in: 

    HKEY_LOCAL_MACHINE\SOFTWARE\[Wow6432Node]\Sophos\EE\Management Tools \DatabaseConnectionMS

    but I've not tried

    If there is a replica of a SOPHOS45 database and you update the connection string and the account the management service is connecting to the database has the necessary rights (should get these by being a member of the "Sophos DB Admins" windows group) you should be able to point the management service at any database.

    Regards,

    Jak

    :21579
Children
No Data