2

A colleague is trying to connect to the MS SQL Server Instance from linux using ODBC driver 17 and get's the below error.

('HYT00', '[HYT00] [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

The Connection string appears as below:

SQL_SERVER = 'Myserver'
SQL_DB = 'Mydatabase'
'DRIVER={ODBC Driver 17 for SQL Server};SERVER=MYServer;DATABASE=MyDatabase;Trusted_Connection=yes'
Marco
3,7205 gold badges25 silver badges31 bronze badges
asked Jul 11, 2018 at 12:53
2
  • Is the port default 1433 ? Commented Jul 11, 2018 at 13:20
  • I've tried 1434 & 1433 ports obtained from the error log and both have failed Commented Jul 11, 2018 at 13:24

1 Answer 1

1

The same issue was reported here. Apparently a change to the settings and the ODBC fixed the issue, you may want to give a try.

Also I'm seeing Trusted_Connection=yes is the authentication possible between the linux and the SQL Server? If not maybe you should go with SQL Authentication.

answered Jul 11, 2018 at 17:27

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.