1. Michael Hartnett
  2. PowerBuilder
  3. Thursday, 29 June 2017 12:55 PM UTC

Hi All,

I am trying to create a Data Source in the Appeon Enterprise Manager that will connect to a SQL Server Instance

localhost/sql2014express

When I use the above servername it does not work.  I know I had seen a resolved case somewhere before, but cannot seem to find it.  I think I needed to use a specific IP/port combination but cannot remember.

Any ideas?

Thank

Michael

Accepted Answer
Chris Pollach Accepted Answer Pending Moderation
  1. Thursday, 29 June 2017 15:23 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Michael;

  Here is what I did for my SS2016 Express ...

1) Make sure that TCP/IP protocol support is turned on in SS. To do that, open the Computer Management console and navigate to the SS area. Once there, locate the Protocols for SS section and after highlighting, ensure that TCP/IP is installed and its enabled (not usually for SS Express), as follows:

2) The next item in the SS console, is to make sure that all aspects are turned on and that SS-X is listening on port 1433. Use the RHMB on the TCPI/IP protocol and then select properties. Then make sure that all TCIP protocols are listening on port 1433 by selecting the IP  Address tab page, scrolling to the end and making sure that for IPALL you set the value 1433., as follows:

3) now make sure that you can connect to SS-X in your PB IDE. Create a SS SNC native connection DB profile in your PB IDE. Make sure that you set the Server to /SQLEXPRESS, also - make sure that you set your Provider to SS2012 or higher if your using a recent SS version, as follows:

 

4) If you can connect to SS-X now from the PB IDE - then you are ready to do the same from your PowerServer. In AEM, create a new DataSource. Set the DS type to MS SQL Server Native Driver. Then set your Server property to \SQLEXPRESS and set the Port to 1433. Now supply your database name and user credentials & press the Test Data Source button. You should receive a succeeded message by AEM, as follows:

HTH

Regards ... Chris

Comment
  1. Michael Hartnett
  2. Sunday, 2 July 2017 12:48 PM UTC
Thanks Chris,



It turned out to be the TCP Port.  I recently upgraded Express to Developer edition and assumed the TCP Port would be filled.



I have updated and it now works.



Thanks



Michael

  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.