cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

luisdarui
Advisor
Advisor
0 Kudos

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".