Remote connecting from CentOS-Cpanel to Win Server 2003 (MSSQL 2005 Express)
"Zack Horne" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <01fb01c98187$ddc91240$640fa8c0@DarkEnigmaa> |
Hi All, I'm trien to remote connect to a windows server 2003 (with mssql 2005 xpress) from a CentOS-Cpanel server. here is my freetds info: # ./tsql -C Compile-time settings (established with the "configure" script) Version: freetds v0.82 freetds.conf directory: /usr/local/freetds/etc MS db-lib source compatibility: yes Sybase binary compatibility: no Thread safety: yes iconv library: yes TDS version: 8.0 iODBC: no When I try to test the connect with ./tsl -S <ip> -U user -P pw... it fails and gives me this error. locale is "en_US.UTF-8" locale charset is "UTF-8" 44Msg 20009, Level 9, State -1, Server OpenClient, Line -1 Unable to connect: Adaptive Server is unavailable or does not exist There was a problem connecting to the server So I took a dump of the connection and here it is aswell. log.c:190:Starting log file for FreeTDS 0.82 on 2009-01-28 13:26:45 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 <private IP> port 1433 (TDS version 8.0) net.c:264:tds_open_socket: connect(2) returned "Operation now in progress" net.c:299:getsockopt(2) reported: Connection timed out util.c:334:tdserror(0x959e0a8, 0x959ea08, 20009, 115) util.c:368:tdserror: client library returned TDS_INT_CANCEL(2) util.c:389:tdserror: returning TDS_INT_CANCEL(2) net.c:310:tds_open_socket() failed mem.c:563:tds_free_all_results()