Nov 24, 2017 at 04:18 AM

HANA SDA with SQL Server Using Port 1433 despite setting up different port in .odbc.ini

316 Views

Hi Experts - I am having an issue where - even though I have set up the .odbc.ini to connect to a SQL Server with static port 9088 (I have already added this as another listening port in SQL Server side, in addition to port 1433), whenever I go to netstat -ano in the target SQL Server, it still shows the connection is on port 1433.

What else can I do to make sure the HANA SDA connects to port 9088 instead of 1433?

These are the different .odbc.ini configurations I have tried but it still keeps going to port 1433!

[<SERVER NAME>]

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

ServerName=<Server Name>

Port=9088

[<SERVER NAME>]

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

ServerName=<Server Name>, 9088

[<SERVER NAME>]

Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

ServerName=<Server Name>:9088

Thanks and regards,

Esteban

Attachments

tcp.png (1.8 kB)