Troubleshooting guide

hdbuserstore set rds myhost:xxxxx my_securestore_user
my_securestore_pwd
where
• rds is the key for the secure store entry
• myhost : xxxxx is the connection environment host name and port number
• my_securestore_user and my_securestore_pwd are SAP Secure User Store credentials
2.
On SAP HANA database, create a maintenance user:
a) As the SAP HANA database admin user, create a user ID with a temporary password:
CREATE USER muser PASSWORD mpwd_temp
b) Log in to SAP HANA database with the temporary password, and then update the
password:
ALTER USER muser PASSWORD mpwd_new
c) Log out of SAP HANA database, and log in again with the new password.
3.
Log in to SAP HANA database:
./hdbsql -u user -p password -i id
where
user is the SAP HANA database user, password is the user password, and id is the
instance number.
4.
On SAP HANA database, grant these authorities to the maintenance user:
GRANT CREATE ANY, DELETE, DROP, EXECUTE,
INDEX, SELECT, UPDATE ON SCHEMA myschema TO muser
where
myschema is your SAP HANA database schema, and muser is the maintenance user
you just created.
5.
Log in to Replication Server:
isql –Usa –Psa_pass –SSAMPLE_RS
If you have not set up the sample Replication Server instance, enter your Replication
Server instance name in place of SAMPLE_RS.
6.
Create a connection to the replicate SAP HANA database instance using ExpressConnect
for HANA DB.
For a standard connection:
create connection to rds.rdb
using profile rs_msss_to_hanadb;ech
set username muser
set password mpwd
go
For SAP Secure User Store:
create connection to rds.rdb
using profile rs_msss_to_hanadb;ech
set username auser
set password apwd
set dsi_connector_sec_mech to "hdbuserstore"
go
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
60 Replication Server