Troubleshooting guide

Task
1.
From the Windows Control Panel, select:
Administrative Tools > Services
2.
In the listed services, find the service named Microsoft SQL Server Analysis Service
(
SERVER
), where
SERVER
is the name of your Microsoft SQL Server data server.
3.
Stop this service.
Enabling TCP/IP
Enable TCP/IP.
Prerequisites
Task
1.
Go to Configuration Tools, and choose SQL Server Configuration Manager > SQL
Server Network Configuration > Protocols for [SQLInstanceName], where
SQLInstanceName
is your SQL Server instance.
2.
Right-click TCP/IP, and choose Enable.
Installing the Microsoft SQL Server JDBC Driver
Install the Microsoft SQL Server JDBC driver.
1.
Go to the Microsoft download site at
http://www.microsoft.com/downloads
and search for
this string:
Microsoft JDBC Driver 4.0
2.
Click the link for the 4.0 driver, and follow the instructions to download and install the
driver.
3. Open Control Panel > System, click the Advanced tab, and click Environment
Variables.
4. In the System Variables window, if the CLASSPATH variable is not listed, click New.
Otherwise, select it, and click Edit.
5.
Enter the full path of the JDBC driver named sqljdbc4.jar, using a semicolon (;) to
separate it from any other drivers.
6. Click OK three times.
Configuring and Validating the Replication Agent Resource File
A single installation of the Replication Agent can support replication from multiple databases.
However, one Replication Agent instance is needed for each Microsoft SQL Server database
that is to be replicated.
1.
Locate the resource file template.
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
66 Replication Server