Re: cannot connect with tsql

2010/9/30 Agnieszka Figiel <[email protected]>

> Hello,
>
> my first time here, so greetings to all!
>
> I found an old thread by Kevin Reed, regarding connecting to mssql
> 2000 with tsql, which seems to describe the exact same problem I'm
> having with mssql 2008:
>
> http://lists.ibiblio.org/pipermail/freetds/2009q1/024223.html
>
> Unfortunately, no solution was posted.
>
> I do not have admistrative access to the mssql instance, but I was
> assured the db and firewall were enabled for me to connect from a
> specified ip address, and indeed I can telnet to 1433. An additional
> requirement is that I need to use encryption, which made me believe
> that my connection is failing due to this:
>
> "Encrypted connections to Microsoft SQL Server 2008 using FreeTDS 0.82
> do not work. Avoid them. Patches welcome! "
>
> However, my tsql dump looks exactly the same as the original poster's,
> and in one of the replies James K. Lowden stated that there's no sign
> of encryption problems there. So what else can it be?
>
> I'm using freetds 0.82-4
>
> The relevant portion of freetds.conf:
>
> [rt]
>     host = [filtered]
>     port = 1433
>     tds version = 8.0
>     client charset = UTF-8
>     encryption = request
>
> The dump:
>
> TDSDUMP=stderr FREETDSCONF=/tmp/freetds.conf tsql -S rt -U [***] -P
> [***] -D [***]
>
> locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> Default database being set to [***]
> log.c:190:Starting log file for FreeTDS 0.82
>        on 2010-09-30 05:54:57 with debug flags 0x4fff.
> iconv.c:197:names for ISO-8859-1: ISO-8859-1
> iconv.c:197:names for UTF-8: UTF-8
> iconv.c:197:names for UCS-2LE: UCS-2LE
> iconv.c:197:names for UCS-2BE: UCS-2BE
> iconv.c:363:iconv to convert client-side data to the "UTF-8" character set
> iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
> iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> net.c:210:Connecting to [***] port 1433 (TDS version 8.0)
> net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:303:tds_open_socket() succeeded
> util.c:162:Changed query state from DEAD to IDLE
> login.c:735:quietly sending TDS 7+ login packet
> token.c:312:tds_process_login_tokens()
> util.c:334:tdserror(0x9a430a8, 0x9a43a08, 20017, 0)
> Msg 20017, Level 9, State -1, Server OpenClient, Line -1
> Unexpected EOF from the server
> util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:389:tdserror: returning TDS_INT_CANCEL(2)
> util.c:162:Changed query state from IDLE to DEAD
> token.c:316:looking for login token, got  0()
> token.c:108:tds_process_default_tokens() marker is 0()
> token.c:111:leaving tds_process_default_tokens() connection dead
> util.c:334:tdserror(0x9a430a8, 0x9a43a08, 20002, 0)
> Msg 20002, Level 9, State -1, Server OpenClient, Line -1
> Adaptive Server connection failed
> util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:389:tdserror: returning TDS_INT_CANCEL(2)
> mem.c:563:tds_free_all_results()
> There was a problem connecting to the server
>
>
> Cheers,
> Agnieszka
>

Apply post-0.82 patches (you can download an updated version at
http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/), compile with kerberos
enabled (see user guide at http://www.freetds.org/userguide/ or after
unpacking distribution) and enjoy.

freddy77