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()
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.