Skip to Content
0

SAP Sybase Unable to connect to primary database as user DR_admin.

Feb 19 at 09:48 AM

63

avatar image
Former Member

Hi Guys,

I am setting up HADR . we are on

SAP ASE 16.0 SP02 PL06 HF1

will use SAP SRS verison is 15.7 SP306

OS is linux.

i am using HADR Users Guide to setup ,

Installing HADR for Business Suite as is SAP ERP

ACTIVITY

setting up an empty database on the standby site but i am getting below error


but i have checked and there is no DR_admin in my primary db as the primary db was already existing.


1> sp_displaylogin DR_admin
2> go
No login with the specified name exists.
(return status = 1)

basically i am adding HADR to my existing SAP ASE.


question,

should i create the DR_admin manually or ?


kind regards,

Elizabeth

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Feb 19 at 09:49 AM
0

this is the error

Unable to connect to primary database as user DR_admin.

kr,

elizabeth

Share
10 |10000 characters needed characters left characters exceeded
Annie Shan
Feb 28 at 10:26 PM
0

I probably will go back to the original hadrsetup log. the resource file should have DR_admin and password.

you can try the following commands:

Create the DR_admin login at the isql command line, logging into the primary and companion servers and execute:

use master
go
create login DR_admin with password <password> suid 1000
go
sp_role "grant", sso_role, DR_admin
go
sp_role "grant", replication_role, DR_admin
go
sp_role "grant", sa_role, DR_admin
go
sp_role "grant", sybase_ts_role, DR_admin
go

Annie

Share
10 |10000 characters needed characters left characters exceeded