Troubleshooting guide

Configuring Replication Agent
Review the procedures for configuring Replication Server for Microsoft SQL Server.
Primary Microsoft SQL Server Configuration and Verification
Review the procedures for configuring and verifying the primary Microsoft SQL Server
database for replication.
Verifying the Compatibility Level of Microsoft SQL Server
Verify that the database compatibility level is set to Microsoft SQL Server 2008, Microsoft
SQL Server 2008 R2, or Microsoft SQL Server 2012.
Replication Agent supports Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, and
Microsoft SQL Server 2012. To verify the compatibility level:
1.
In the Microsoft SQL Server Management Studio, right-click your primary database and
select Properties.
2.
In Database Properties, click Options, and verify that the compatibility level is "Microsoft
SQL Server 2008 (100)." If it is not, select that compatibility from the drop-down list, and
click OK.
Disabling Microsoft SQL Server Replication
A Microsoft SQL Server publication cannot be created in the primary database used by
Replication Agent for Microsoft SQL Server, and you cannot simultaneously use Microsoft
replication and Replication Agent on the same Microsoft SQL Server database.
If a Microsoft SQL Server publication already exists, remove the publication before using
Replication Agent for Microsoft SQL Server.
Creating a Microsoft SQL Server User and Granting Permissions
Create a Microsoft SQL Server user named “ra_user,” and grant permissions to the user.
Log in to the primary Microsoft SQL Server as a system administrator, and run:
use master;
create login ra_user
with password 'my_pass';
use <primary_database>;
create user ra_user for login ra_user;
EXEC sp_addsrvrolemember 'ra_user','sysadmin';
Where
my_pass is a password that complies with the Microsoft SQL Server complexity
policy.
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
62 Replication Server