1. Hannu Pikkarainen
  2. PowerBuilder
  3. Friday, 30 June 2023 14:38 PM UTC


I have installed PB 2022 R2 and MS SQL Server 2019 to a Windows 2019 server on Azure.

While installing PB I could not connect to SQL server to install demo database.

Now same problem when I try to create Power Server Project.

From PB IDE I can connect SQL server with MSOLEDBSQL, SNC Native client driver and ODBC Driver 17 without a problem. Connections work with both Windows and SQL server authentication.

I have also tested with SQL Server Manager Studio by forcing it to use TCP-connection and it works without problems.


Any suggestions?

BR, Hannu

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 30 June 2023 15:28 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Hannu;

  This is normal issue when 1st installing any SS Express DBMS edition as A) PB uses TCP/IP connectivity and B) SS Express installs with TCP/IP Off by default (go figure - LOL).

Here is what you need to do ...

1) Run "SQL Server 2022 Configuration Manager" (or what ever SS version you have installed)...

2) Enable TCP/IP ...

3) Once TCP/IP is enabled, double-click the TCP/IP label for another dialogue to appear

4) Select the "IP Addresses" tab page.

5) Scroll down to the "IPALL" entry

6) Set the TCP/IP port to 1433, as follows:

7) Restart SS Express

You should now be able to login OK.


Regards ... Chris

  1. Hannu Pikkarainen
  2. Saturday, 1 July 2023 08:27 AM UTC
Thanks Chris, this was exactly my problem.

BR, Hannu
  1. Helpful
  1. Chris Pollach @Appeon
  2. Saturday, 1 July 2023 12:24 PM UTC
Hi Hannu;

That's great news & thanks for the feedback!

Regards ... Chris

  1. Helpful
There are no comments made yet.

There are replies in this question but you are not allowed to view the replies from this question.