FreeTDS problem connecting to SQL Server on Mac (Unexpected EOF from the server)

Question

I have setup FreeTDS to connect to SQL Server database. When I try to open TSQL in terminal on Mac (lion) I get this error:

locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20017 (severity 9):
    Unexpected EOF from the server
    OS error 36, "Operation now in progress"
Error 20002 (severity 9):
    Adaptive Server connection failed
There was a problem connecting to the server

Does anybody have a clue what could be causing this?

having the exact same issue here, attempting to connect to a SQL Server 2008 R2 server, hosted on a Win 2008 SP2 64 bit server, from lion with tsql — gabouy, Aug 13 '11 at 16:51

score 11 · Answer 1 · edited Oct 19 '15 at 16:54

11

I think I got it, it's the TDS configured version, I had 5.0, which caused the error

Try running tsql -C to check what version are you using, and then you can invoke tsql overriding the version with:

TDSVER=7.0 tsql -H hostname -p port -U domain\\\username -P password

and it worked!

edited Oct 19 '15 at 16:54

frogatto

28,539
11
83
129

answered Aug 13 '11 at 17:04

gabouy

755
1
7
16

score 9 · Accepted Answer · edited Oct 19 '15 at 16:51

9

To make this permenant I found I need to edit the freetds.conf file and set it globally in there

vim /usr/local/freetds/etc/freetds.conf

tds version = 8.0

running tsql -C still showed that the version was 5.0 but connecting now worked every time.

edited Oct 19 '15 at 16:51

frogatto

28,539
11
83
129

answered Mar 02 '12 at 11:38

John

218
2
5

Yep, the version 5.0 in the tsql -C definitely threw me off, but changing the tds version to 8.0 fixed this error. – YonkeyDonk64 Jul 23 '14 at 14:32
2

In my case the file was in `/etc/freetds/freetds.conf`. – monteirobrena Apr 14 '16 at 13:49
1

Connection works with 7.3 with all versions including Azure. You're not supposed to use 8.0 anymore: http://www.freetds.org/userguide/choosingtdsprotocol.htm – Rick O'Shea Nov 22 '17 at 20:58

score 8 · Answer 3 · edited Sep 30 '12 at 00:56

TDS version need to match the correct tds protocol to connect to your db server, see below -

http://www.freetds.org/userguide/choosingtdsprotocol.htm

Choosing a TDS protocol version

***DB SERVER        |    TDS VERSION ***    
Microsoft SQL Server 6.x    = 4.2       
Sybase System 10 and above  = 5.0       
Sybase System SQL Anywhere  = 5.0     
Microsoft SQL Server 7.0    = 7.0       
Microsoft SQL Server 2000   = 7.1       
Microsoft SQL Server 2005   = 7.2   
Microsoft SQL Server 2008   = 7.2

score 2 · Answer 4 · edited Nov 06 '12 at 09:33

2

Also missing symlink on libtdsodbc.so in /usr/lib/odbc (for me)

sudo ln /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so libtdsodbc.so

should help

edited Nov 06 '12 at 09:33

Sirko

72,589
19
149
183

answered Nov 06 '12 at 09:12

Serg Anuke

168
2
11

score 1 · Answer 5 · answered Jul 07 '17 at 17:02

I was having the same problem. In my situation, the username for the Microsoft SQL Server database was in the form, DOMAIN\userid. However, when I typed it on the command line, I think it was interpreting the slash as an escape character. When I tried putting the slash the other direction, it still failed. Finally, I tried putting two slashes in the original direction and it worked. Thus the following worked for me:

tsql -S myhost -U DOMAIN\\userid

score 0 · Answer 6 · edited Apr 19 '19 at 18:10

0

I encountered the same error. Then I did the following, and the error went away:

pip install pyodbc
Previously, I had used quotes for the DB server, username, and pwd in the TSQL command. This time, I removed the quotes.

edited Apr 19 '19 at 18:10

MarredCheese

17,541
8
92
91

answered Apr 19 '19 at 16:48

quietdr1105

1

FreeTDS problem connecting to SQL Server on Mac (Unexpected EOF from the server)

6 Answers6

Linked