Sql-server – Error connecting to MSSQL server from Linux

linuxodbcsql server 2014

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'

Best Answer

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.

Related Solutions

Sql-server – ODBC SQL Server driver on Linux/nginx

I'd say you miss a post for your instance in /etc/freetds.conf. The post should look something like this

[my_alias]
    host = some_db_host_address
    port = 1433
    tds version = 8.0

Then in your connection string you should use that alias. The host and port part shouldn't be needed as they are picked up from the configuration file. You may have to say which driver to use. This works for me

$conn = odbc_connect("Driver=FreeTDS;DSN=my_alias","user","pass");

Sql-server – Problem when connecting to SQL Server

_{This answer is intentionally Community Wiki to encourage others to edit in other useful links and information for troubleshooting connection problems.}

Please try:

Both are Microsoft TechNet guides targeted at your type of problem.

Aaron Bertrand wrote a blog post listing many different error codes for login related connection errors

The Stack Overflow Q & A Help troubleshooting SqlException: Timeout expired on connection, in a non-load situation provides lot of good pointers to check on a box facing this type of issue.

Best Answer

Related Solutions

Sql-server – ODBC SQL Server driver on Linux/nginx

Sql-server – Problem when connecting to SQL Server

Related Question