Re: help with "login packet rejected"

Randy Syring <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Please disregard.  Turns out I can't login from SQL Management Studio 
Error either.  Screen shot:



I'll report back for Google's sake once they figure out what is wrong.

*Randy Syring*
Husband | Father | Redeemed Sinner

/"For what does it profit a man to gain the whole world
and forfeit his soul?" (Mark 8:36 ESV)/

On 10/07/2014 07:07 PM, Randy Syring wrote:
> I have a system that has been running against a QA MSSQL 2005 server 
> (SQL7) without problems for a day or so.  I switched it over to our 
> production MSSQL 2005 server (SQL1) and I can't get connected.  My 
> TDSDUMP is:
>
> log.c:196:Starting log file for FreeTDS 0.91
>     on 2014-10-07 19:03:24 with debug flags 0x4fff.
> config.c:714:Setting 'dump_file' to '/tmp/freetds.log.2802' from $TDSDUMP.
> iconv.c:330:tds_iconv_open(0x2055d20, UTF-8)
> iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
> iconv.c:187:local name for UTF-8 is UTF-8
> iconv.c:187:local name for UCS-2LE is UCS-2LE
> iconv.c:187:local name for UCS-2BE is UCS-2BE
> iconv.c:349:setting up conversions for client charset "UTF-8"
> iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
> iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
> iconv.c:394:tds_iconv_open: done
> net.c:205:Connecting to 172.0.255.12 port 1433 (TDS version 7.1)
> net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:310:tds_open_socket() succeeded
> util.c:156:Changed query state from DEAD to IDLE
> net.c:741:Sending packet
> 0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
> 0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
> 0020 55 00 00 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
> 0030 f2 0a 00 00            - |....|
>
> util.c:331:tdserror(0x1da8790, 0x2055d20, 20004, 104)
> dblib.c:7929:dbperror(0x260a6a0, 20004, 104)
> dblib.c:7981:20004: "Read from the server failed"
> dblib.c:8002:"Read from the server failed", client returns 2 (INT_CANCEL)
> util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:384:tdserror: returning TDS_INT_CANCEL(2)
> util.c:156:Changed query state from IDLE to DEAD
> login.c:466:login packet rejected
> util.c:331:tdserror(0x1da8790, 0x2055d20, 20002, 0)
> dblib.c:7929:dbperror(0x260a6a0, 20002, 0)
> dblib.c:7981:20002: "Adaptive Server connection failed"
> dblib.c:8002:"Adaptive Server connection failed", client returns 2 
> (INT_CANCEL)
> util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:384:tdserror: returning TDS_INT_CANCEL(2)
> dblib.c:1443:dbclose(0x260a6a0)
> dblib.c:258:dblib_del_connection(0x7f279cfc8840, 0x2055d20)
> mem.c:615:tds_free_all_results()
> dblib.c:305:dblib_release_tds_ctx(1)
> dblib.c:5882:dbfreebuf(0x260a6a0)
> dblib.c:739:dbloginfree(0x25beb40)
>
> Thoughts on where I can go from here?
>
> *Randy Syring*
> Husband | Father | Redeemed Sinner
>
> /"For what does it profit a man to gain the whole world
> and forfeit his soul?" (Mark 8:36 ESV)/
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.