SWPM - ASE ("unable to connect to database as user sapsa"

[Private_Member_19084]

Hi experts,

I want to do a system copy with SWPM (productive to quality system).

Both are ASE based and therefore it is a homog. copy.

However, there is one step (Database User Password (sapsa).

I enter the correct password, but I get the error "Unable to connect to database as user 'sapsa'".

I've checked the password of sapsa and it is correct, as I can join with isql.

Any ideas what is causing this?

Kind regards

[AtulKumarJain · Accepted solution]

Hi Christian,

Please check using

isql -S <server_name> -U sa -P <pwd>

Also please make sure that db is up and running

Best Regards,

AKJ

[Private_Member_19084 · Accepted solution]

Hello AKJ,

this is working and I can login.

But I get the error message in SWPM by trying to copy the ASE-Db.

Kind regards

[AtulKumarJain · Accepted solution]

Hi Christian,

As you are doing the system copy.

Can you use the passowrd which is for sapsa user in production system.

BR

AKJ

[Private_Member_19084 · Accepted solution]

Hello Akj,

not at that step, there it is the password of target system, I still haven't defined source-system, therefore it must be the target-one.

[Private_Member_19084]

The problem is solved.

I don't really now what was the problem, I did reboot the host and also drop some startups.

Now I have another problem with the stop of the system

[Sriram2009]

Hi Christian

At OS level are you able to logon to ASE DB with same credential?

BR

SS

[Private_Member_19084]

Hello Sriram,

yes, thats confusing me (with -X and without)