Skip to Content

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

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

tcp.png (1.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 19, 2017 at 08:36 PM

    Hi Esteban,

    In the .odbc.ini file you have entered it incorrect. The correct values are:

    Driver=<driver_path>
    Server=<server>,<port>

    Always check the port in the ERRORLOG file.

    This is transparent to HANA since it will connect to the data source name you have defined in the .odbc.ini, so all you need to do is test the access to SQL Server through isql.

    isql -v <datasourcename> <user> <password>

    Then run "SELECT @@VERSION".

    Add comment
    10|10000 characters needed characters exceeded