Troubleshooting guide

Prerequisites
Review the prerequisites before you begin setting up Microsoft SQL Server-to-SAP HANA
database replication.
Make sure:
• You are familiar with Microsoft SQL Server and SAP HANA database.
• You have valid licenses for Replication Server with ExpressConnect for HANA DB and
Replication Server Options.
• You have valid licenses for Replication Server and Replication Server Options.
• Microsoft SQL Server 2008 is installed and configured to serve as the source (primary)
database from which Replication Agent replicates transactions, and SAP HANA database
is installed and configured as the target (replicate) database to which Replication Server
with ExpressConnect for HANA DB replicates transactions.
• Microsoft SQL Server JDBC driver 1.2 is installed.
• TCP/IP connectivity is available between all hosts.
Because Replication Agent for Microsoft SQL Server is limited to the Microsoft Windows
platform, all examples shown are for Windows.
Note: On Windows Vista and Windows Server 2008, you must be logged in as an
Administrator.
Do not use Replication Server reserved words for object names or connection names. A
complete list of reserved words is in the Replication Server Reference Manual .
Planning Your Installation
Before installing the replication components, verify the system requirements, identify the
Sybase installation directories, and obtain the installation software.
System Requirements
Make sure the target computer on which you are installing the replication components meets
the minimum memory and disk space requirements.
See the Replication Server Installation Guide > Planning Your Installation > System
Requirements and the Replication Agent Installation Guide > Planning Your Installation >
System Requirements .
To improve performance by avoiding multiple network hops, install Replication Server and
the SAP HANA database on the same machine.
Note: The only versions of Linux that ExpressConnect for HANA DB supports are Red Hat
Enterprise Linux 6 and SuSE Linux Enterprise Server (SLES) 11.
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
52 Replication Server