title: pymssql and Adaptive Server connection failed
body: <p>When I try to connect into Azure database by Pymssql in python I face this error:</p>
  
  <pre><code>pymssql.OperationalError: (20002, 'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (iprice-bi.database.windows.net:1433)\n')
  </code></pre>
  
  <p>I connect to the database by tsql command:</p>
  
  <pre><code> tsql -H server -p 1433 -U username -P password
  
  locale is "en_US.UTF-8"
  </code></pre>
  
  <p>locale charset is "UTF-8"
  using default charset "UTF-8"
  1> SELECT @@version
  2> GO</p>
  
  <pre><code>Microsoft SQL Azure (RTM) - 12.0.2000.8 
  Mar  1 2016 22:36:40 
  Copyright (c) Microsoft Corporation
  
  (1 row affected)
  </code></pre>
  
  <p>I checked freetds.conf as well to be sure I am using correct version.</p>
  
  <pre><code>[global]
  # TDS protocol version
  tds version = 7.0
  dump file = /tmp/freetds.log
  dump file append = yes
  </code></pre>
  
  <p>results for log file also does not give any clue. </p>
  
  <pre><code>log.c:167:Starting log file for FreeTDS 0.95.87
  on 2016-03-25 16:50:51 with debug flags 0x4fff.
  dblib.c:1237:tdsdbopen: Calling tds_connect_and_login(0x23f9b00, 0x23fde90)
  iconv.c:328:tds_iconv_open(0x23f9b00, 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:346:setting up conversions for client charset "UTF-8"
  iconv.c:348:preparing iconv for "UTF-8" &lt;-&gt; "UCS-2LE" conversion
  iconv.c:395:preparing iconv for "ISO-8859-1" &lt;-&gt; "UCS-2LE" conversion
  iconv.c:400:tds_iconv_open: done
  net.c:202:Connecting to 23.100.117.95 port 1433 (TDS version 7.1)
  net.c:275:tds_open_socket: connect(2) returned "Operation now in progress"
  net.c:314:tds_open_socket() succeeded
  packet.c:740: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 02 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
  0030 d7 33 00 00            -                        |.3..|
  
  packet.c:639:Received packet
  0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|
  0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 0c 00 02 |........ ........|
  0020 bf 00 00 03 00         -                        |.....|
  
  login.c:1106:detected flag 3
  login.c:472:login packet rejected
  query.c:3772:tds_disconnect() 
  util.c:165:Changed query state from IDLE to DEAD
  util.c:322:tdserror(0x24f4290, 0x23f9b00, 20002, 0)
  dblib.c:7925:dbperror(0x23f8fb0, 20002, 0)
  dblib.c:7993:dbperror: Calling dblib_err_handler with msgno = 20002;      msg-&gt;msgtext = "Adaptive Server connection failed (SERVERNAME:1433)"
  dblib.c:8015:dbperror: dblib_err_handler for msgno = 20002; msg-&gt;msgtext  = "Adaptive Server connection failed (SERVERNAME:1433)" -- returns 2 (INT_CANCEL)
  util.c:352:tdserror: client library returned TDS_INT_CANCEL(2)
  util.c:375:tdserror: returning TDS_INT_CANCEL(2)
  dblib.c:1241:tdsdbopen: tds_connect_and_login failed for "SERVERNAMR:1433"!
  dblib.c:1463:dbclose(0x23f8fb0)
  dblib.c:243:dblib_del_connection(0x7f066cb036a0, 0x23f9b00)
  mem.c:648:tds_free_all_results()
  dblib.c:290:dblib_release_tds_ctx(1)
  dblib.c:5873:dbfreebuf(0x23f8fb0)
  dblib.c:743:dbloginfree(0x24439f0)
  </code></pre>
  
  <p>does Anybody face such problem or can give me some suggestions for solve it?!</p>