[freetds] Cannot connect to MS SQL 2008 server from OS X using FreeTDS
Frediano Ziglio
freddy77 at gmail.com
Sat Apr 7 03:20:35 EDT 2012
Il giorno 07/apr/2012, alle ore 01:46, Paul Wuersig <pwuersig at nvidia.com> ha scritto:
> The basic error looks like so:
>
> $ tsql -H <hostname> -p 1433 -U <user>
> Password:
> 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
>
> This is identical to the error from using tsql to connect to *any* open port!
>
> Connecting with "-S <server> -U <user>", or connecting to any closed port, produces error 20009:
> Error 20009 (severity 9):
> Unable to connect: Adaptive Server is unavailable or does not exist
> OS error 61, "Connection refused"
>
> I can connect to the server just fine using MS SQL Server Management Studio on Windows XP.
>
> I've tried other MS-SQL servers, which produce the same errors.
>
> I've tried FreeTDS 0.82, 0.91, and freetds-0.92.dev.20120312 (latest). Same errors on all of them (although the errors are printed slightly differently in 0.82).
>
> I've tried 0.92 with "MS db-lib source compatibility" enabled, with the same results.
>
> The server has an entry in /usr/local/etc/freetds.conf. I've tried tds version 0, 5.0, 7.0, 7.1, 7.2, and 8.0, with the same results.
>
> I've Googled this extensively, and I've tried essentially all the things people have suggested for similar errors.
>
> This is on a Mac running 10.7.3.
>
> Suggestions, or things to try, or more information I can give that might prove fruitful, are all appreciated!
>
> Thanks,
> Paul
>
Did you enable OpenSSL or GnuTLS?
Frediano
More information about the FreeTDS
mailing list