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

Resolved PowerServer Project Database configuration

  1. Issue
0
Votes
Undo
  1. Tim Moulaison
    Tim Moulaison
  2. PowerServer
  3. Thursday, 26 January 2023 16:27 PM UTC

I am attempting to convert a PB2022 project using PowerServer. I have installed PowerBuilder 2022 and have converted my PB2019 project to PB2022.  I have successfully created and connected to my SQL Server 2016 database using the SNC SQL Native Client database profile.

I am trying to update the PowerServer Project Database Server connection setup information.  The Provider is SQL Server.  I have tried using all the different Authentication selections but end up with the same error:

 

Can anyone explain how to resolve this issue?

 

Thank you.

 

 

  1. Database Profile
  2. PowerServer
PowerServer 2022 Java Dependency
PowerServer and relative path of resources, how to...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 26 January 2023 16:44 PM UTC
  2. PowerServer
  3. # Permalink

Hi Tim;

  It sounds to me (I could be wrong) that you have requested a "secure" connection to SS but have not provided a "certificate" or the correct settings for that - in your PS's "DB Cache" definition. Could that be your issue (just a guess)?

Regards ... Chris

Comment
There are no comments made yet.
Responses (2)
Tim Moulaison
Tim Moulaison Accepted Answer Pending Moderation
  1. Thursday, 26 January 2023 18:31 PM UTC
  2. PowerServer
  3. # 1

The Trust Server Certificate was set to False.  Changed it to True and the Test Connection was successful.  

 

Thank you.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 26 January 2023 18:49 PM UTC
Hi Tim .. that's awesome news!

Yes, the reverse would be true as well. If your SS engine has the certificate requirement checked, then any "potential" client logging into SS must them also present a certificate in order to connect sucessfully. :-)
  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.