• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • AEM Data source Dynamic User Password is set to null

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved AEM Data source Dynamic User Password is set to null

  1. Misc
0
Votes
Undo
  1. Jon Tzeng
    Jon Tzeng
  2. PowerServer
  3. Friday, 26 January 2024 18:38 PM UTC

Hello,

We use PowerServer 2020 Build 2703. On AEM Data Source, we have Dynamic Database Connection and Pooling is on. We use long connection setting and connection-cache.config file has appeon_user and appeon_pwd setting. In the beginning of the application object open event we use a database system account to connect to the database.

Sometime we would find out a user try to launch the application and get "null password given: logon denied" error. We check the AEM and the uncheck the Dynamic Database Connection and would find out the User Name is set to this database service account with null password in there. We reset the ID and password but when this user try to launch the application, the ID be reset to the database service account and null password.

Do you have any idea how this would happen and how to prevent it?

Thanks.

 
 
Changing web_api apprun.json for testing reverse ...
Can Powerserver/CAL install .Net runtime on Client...
Responses (3)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 22 February 2024 00:51 AM UTC
  2. PowerServer
  3. # 1

Hi Jon,

Is this the only user that has this issue? Do he fail to logon to both of the servers or just one of the servers? This might be caused by the special characters in the password. Please try to use a simple password and please also try having this user running the application on other client machine.

If there is still the issue, please open a support ticket in the support portal and please provide the PowerServer log (debug mode) to us for more study, Many thanks in advance.
https://www.appeon.com/standardsupport/

Regards,
Kai

Comment
There are no comments made yet.
Jon Tzeng
Jon Tzeng Accepted Answer Pending Moderation
  1. Wednesday, 21 February 2024 20:44 PM UTC
  2. PowerServer
  3. # 2

Hello Kai,

Yes, we do have the SQLCA.LogId = %your id% and SQLCA.LogPass=%your pass% setup correctly. The issue is this issue happens on one user. We have two app servers and it looks like the user cannot logon on one serer and whenever the user try to launch from that serve, the user password of the data source setup on the AEM will be wiped out, even we restart the IIS and it would not fix the issue.

Comment
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Monday, 29 January 2024 01:52 AM UTC
  2. PowerServer
  3. # 3

Hi Jon,

When the Dynamic Database Connection feature is turned on, the LogID and LogPass of the Transaction object will be used to connect to the database; so please make sure you have set the correct password at the beginning of the application object open event.

For example, you can use the script like below to specify the user/password to connect to the database.

SQLCA.LogId = %your id%
SQLCA.LogPass=%your pass%

Regards,
Kai

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.