HP Storage Mirroring Software - Manual (Page 54)

Storage Mirroring Recover requirements Page 53 of 677
l
The source and target servers should be in the same domain. If they are not,
the SQL Server service on both the source and target servers must be
configured to start with the same domain user account.
l
If your source and target are in a workgroup, make sure the source server's
NIC does not register the IP addresses with DNS.
l
In order to protect SQL named instances, both the source and target servers
must have named instances with the same name installed prior to configuring
protection.
l
If you are using SQL 2005 and are using a domain service account that is not
in the domain or local Admins security group, the replicated databases will
not mount on the target because of security restrictions at the file system
level. You need to place the SQL 2005 service account in the local Admins
group on the target.
l
If you are using SQL 2008, local group permissions are not copied to the
target during failover. You will need to use a domain Admin account as the
SQL service account or manually copy the group permissions to the target.
l
Storage Mirroring Recover does not support a SQL default instance that is
using non-default ports.
l
If you are protecting a cluster configuration, ideally you should have only one
instance of SQL Server per owning node on your source and target cluster.
This decreases the risk of problems when attempting to re-enable protection
after failover and failback. The following problems may occur if multiple
instances reside on the same owning node.
l
After failover and failback, you will be able to re-enable protection on the first
instance, but when you try to protect subsequent instances, after selecting
the source instance, Application Manager will erroneously show that the
instance is already protected. Contact technical support to obtain instructions
for fixing this issue.
l
If one instance is failed over, replication will stop on the other protected
instances. On the other instances that are not failed over, you will need to
perform a difference mirror in order to resume protection.
l
Application Manager Console—The following limitations apply to the Application
Manager Console when protecting SQL.
l
If you are using a cluster configuration, you should run the console from a
target node.
l
If you want to run the console from a Vista client to protect a cluster, you will
need to install the Microsoft Remote Server Administration Tools (RSAT).
Installing this package will allow you to install the Failover Cluster Manager
component on a Vista client so it can communicate with and administer
Windows 2008 clustered environments.