• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • PowerServer client error Login failed for user ''

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

Resolved PowerServer client error Login failed for user ''

  1. Issue
0
Votes
Undo
  1. Hannu Pikkarainen
    Hannu Pikkarainen
  2. PowerServer
  3. Tuesday, 24 October 2023 10:35 AM UTC

Hi,

I am deploying a application through PowerServer.

I have 2 identical environmentsn (?), Win 2019 server & MS SQL Express 2019

On test environment everything works without problem, but when I deploued application to Prod-env and try to install it to client, I get error database connection failed and SQLCA.SQLErrText returns Login failed for user ''.

When running application locally on prod-server with PB IDE everything works correctly.

What could cause this problem?

BR, Hannu

 

Attachments (1)
Pic7.PNG Pic7.PNG
  1. PowerServer
Error connecting to DB from PS 2022 app
PBVM Crash
Accepted Answer
Hannu Pikkarainen
Hannu Pikkarainen Accepted Answer Pending Moderation
  1. Sunday, 19 November 2023 13:04 PM UTC
  2. PowerServer
  3. # Permalink
  1. Hannu Pikkarainen
    2.  
  2. less than a minute ago
    3.  
  3.  Remove
Hi all,

We found the cause for this error.
The configuration in the application.json within appconfig had the password set to null. I don't know why, but after correcting this everything works fine.

BR, Hannu
Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Sunday, 19 November 2023 16:12 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Responses (4)
Hannu Pikkarainen
Hannu Pikkarainen Accepted Answer Pending Moderation
  1. Tuesday, 24 October 2023 11:46 AM UTC
  2. PowerServer
  3. # 1

I changed settings so the Prod-env client connects to dev-database and everything works fine. So there must be something in prod-env SQL Express that causes tis problem. What could it be, every parameter seems to be exactly same.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 24 October 2023 12:36 PM UTC
Hi Hannu;

Since your using SS Express DBMS, the most likely cause is that your DB Server installation did *not* turn on the TCP/IP protocol. Both PB & PS need this protocol enabled. HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Hannu Pikkarainen
Hannu Pikkarainen Accepted Answer Pending Moderation
  1. Tuesday, 24 October 2023 11:23 AM UTC
  2. PowerServer
  3. # 2

Yes

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 24 October 2023 11:04 AM UTC
  2. PowerServer
  3. # 3

Hi.

Do you set the correct database in production environment?

Comment
Hannu Pikkarainen
  1. Hannu Pikkarainen
  2. Sunday, 19 November 2023 13:03 PM UTC
Hi all,



We found the cause for this error.

The configuration in the application.json within appconfig had the password set to null. I don't know why, but after correcting this everything works fine.



BR, Hannu



  1. Helpful
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.