Sql manager requirements – HP Storage Mirroring V5 Software User Manual
Page 16
6
Introduction
•
The Exchange configurations on the source and target servers must be identical for the following
components:
• Storage groups
• Location of storage groups (log and data files)
• Log file prefixes
• Database locations (log and data files)
• Message Transfer Agent (MTA) location
• Queue paths
•
In a parent\child domain, at least one domain controllers in the child domain must designated as a global
catalog server.
•
The Application Manager does not support configurations where Exchange and the domain controller are
on the same node of a cluster.
•
While installing Exchange Server 2003 on a domain controller is a supported operation, it is not generally
recommended. Hewlett-Packard also does not recommend this configuration. If you must use Exchange
Server 2003 on a domain controller, review the following Microsoft Knowledge Base articles:
http://support.microsoft.com/kb/822179
http://support.microsoft.com/kb/332097
http://support.microsoft.com/kb/305065
http://support.microsoft.com/kb/304403
http://support.microsoft.com/kb/875427
SQL Manager requirements
If you are using the Storage Mirroring Application Manager for SQL, your system must meet the following
requirements:
•
Two licensed copies of Microsoft SQL Server that meet one of the following requirements:
• SQL Server 2000 with Service Pack 4 or later
• SQL Server 2005
NOTE:
If you are using SQL Server, you will be prompted to download and install the Microsoft SQL
Server 2005 backward compatibility components. This package includes the SQLDMO library, which
is required to run the Application Manager.
You should use the same version and service pack of SQL Server on both the source and target servers.
The only exception would be that you may use a newer version of SQL Server on the target server to
perform a failover while in
Database Only
protection mode (for instance, when using Storage Mirroring
Application Manager to facilitate a migration from SQL Server 2000 on the source to SQL Server 2005
on the target). You can
NOT
failback when using different versions of SQL Server on the source and
target.
•
To enable the Application Manager to work with MSDE (SQL Express 2000) and SQL Server 2005
Express, Named Pipes and TCP/IP need to be added to the Enabled Protocols. By default, these are
disabled. They must be enabled to accept remote connections.
• For MSDE, you must run the
svrnetcn.exe
command, which is located in the
C:\Program
Files\Microsoft SQL Server\80\Tools\Binn
directory.
• For SQL Server 2005 Express, you must launch the
SQL Server Configuration Manager
, expand
SQL Server
2005 Network Configuration
, and for
Protocols for MSSQLSERVER
enable
Named Pipes
and
TCP/IP
.
•
To use the Storage Mirroring Application Manager for SQL, the user logged on to Windows
must
be a
member of the SQL Server
sysadmin
role on the source and target servers.
•
The source and target SQL servers
must
be in the same domain; otherwise, the SQL Server service on both
the source and target servers must be configured to start with the same domain user account.
•
In order to protect SQL named instances, both the source and target SQL Servers must have named
instances with the
exact
same name installed
prior
to configuring protection.