Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    this is the error

    Unable to connect to primary database as user DR_admin.

    kr,

    elizabeth

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28 at 10:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded