1. Saroj Mungtaweepongsa
  2. PowerBuilder
  3. Thursday, 6 July 2017 15:54 PM UTC

In PowerBuilder 2017 IDE Database profile, I can normally connect on cloud remote database using MS SQL Server Native connection.

 

But, not in PowerServer & AEM.

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 July 2017 16:11 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sarji;

  Did you turn on TCP/IP processing on in SS Express. Normally, this protocol  is off upon the initial SS Express installation. Both PowerBuilder IDE and the PowerServer needs to have this protocol active in SSX when you create a DB Profile in PB or a DataSource Connection profile is PS.

HTH

Regards ... Chris

Comment
  1. Saroj Mungtaweepongsa
  2. Thursday, 6 July 2017 16:33 PM UTC
Already turn on everything. And also temporary turn off firewall.















 



Inform you again, I can connect from PowerBuilder IDE. But not PowerServer .

  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 6 July 2017 16:46 PM UTC
Hi Saroj;



      Oh yes, PowerServer is 64 bit - so make sure that you have both the 32bit & 64bit SNC clients are installed from SSX.



Could that be it?



Chris

  1. Helpful
There are no comments made yet.
Appeon Support Team Accepted Answer Pending Moderation
  1. Friday, 7 July 2017 00:50 AM UTC
  2. PowerBuilder
  3. # 2

Hi,

 

If there are mutiple SQL Server instances on server machine? please check the the correct port is 1433. please refer to article below to solve this issue.

https://support.appeon.com/index.php?/Knowledgebase/Article/View/48/11/cannot-connect-to-the-sql-server

 

Regards,

ZhaoKai

Comment
  1. Saroj Mungtaweepongsa
  2. Friday, 7 July 2017 02:20 AM UTC
HI ZhaoKai



 



I can solve this issue by follow your answer.



 



Thank you so much



Saroj

  1. Helpful
  1. Appeon Support Team
  2. Friday, 7 July 2017 06:24 AM UTC
Hi,



Glad to hear that. you aer welcome!.



Regards,

ZhaoKai

  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.