Connecting to SQL Server

[ramaraosrikakulapu]

This is to document an experience with a customer for connecting to a on prem SQL Server database.

• Target System: On prem SQL Server database
• Agent version: v1.1beta.fukuoka.2725
• Gateway: In predix
• EC Server: On prem
• EC Client: Linux VM in AWS VPC
• Client app: TC running in container in linux VM where EC client deployed

Server agent using the DB host name as rht and port 1433 (default port for SQL Server in general) and successfully established super connection with predix gateway

Issue: From the logs EC client running fine but unable to make successful connection with URL -

jdbc:sqlserver://{EC Client host IP}:{lpt};databaseName={dbName}

[ramaraosrikakulapu]

Resoultion: 1433 is port for SQL Server in general but not always. So get the right port number as follows -

• Connected to the DB from VS code tool in 'on prem' network, which not required to give the port number
• Run netstat command to get the right port number in terminal with db ip address -

  $ netstat -a | grep 10.10.10.10
  tcp4       0      0  3.3.3.3.54551     10.10.10.10.54715     ESTABLISHED
  tcp4       0      0  3.3.3.3.54547     10.10.10.10.54715     ESTABLISHED

• Change the rpt port number to 54715