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

Resolved Can't connect local SQL server 2019 Express

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

Hi,

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

  1. Database
  2. PowerServer
  3. SQL Server
Response Window getting Lost
How to use Ctrl++ as a Ribbonbar shortcut
Accepted Answer
Chris Pollach @Appeon
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.

HTH

Regards ... Chris

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



BR, Hannu
  1. Helpful
Chris Pollach @Appeon
  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.
Responses (1)


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