Re: Unable to connect: Adaptive Server is unavailable or does not exist

Thank you for your reply. 

I have verified that I can connect to the SQL server via telnet. 

When I run my command: tsql -H myserver.ip -p 1443 -U myuser, I am prompted for the password and then get the message below. Here is the freetds.log file:

log.c:190:Starting log file for FreeTDS 0.82
   on 2010-06-09 08:23:09 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"
net.c:210:Connecting to 159.121.122.6 port 1443 (TDS version 5.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:299:getsockopt(2) reported: Connection refused
util.c:334:tdserror(0x86db0a8, 0x86dba60, 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()

Christopher Adams

> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of David Dick
> Sent: Tuesday, June 08, 2010 4:19 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Unable to connect: Adaptive Server is
> unavailable or does not exist
> 
> On 09/06/10 08:45, Chris Adams wrote:
> > Hello,
> >
> > This is my first post to this list. I am a new user of freetds. Here
> is my scenario. I am trying to connect from a Redhat ES3 (old,yes I
> know) box to a MSSQL Server 2005 databse.
> >
> > I have installed the latest stable version of freetds on the Linux
> box. I run the tsql command like this:
> >
> > Tsql  -H my.host.ip.address -p 1443 -U sa
> >
> > The result is this:
> >
> > tsql -H  my.host.ip.address -p 1443 -U sa
> > locale is "en_US.UTF-8"
> > locale charset is "UTF-8"
> > Password:
> > Msg 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
> >
> >
> > I have tinkered with older versions of freetds, had the freetds-devel
> installed and installed unixodbc. I may have missed some steps and am
> missing parts that are needed.
> >
> > Could someone point me in the right direction so that I don't
> continue spinning my wheels here? Thanks.
> 
> Ok.  First, you need to make sure that SQL Server is actually listening
> on port 1433.  I would recommend using telnet to test the connection
> from your ES3 server.
> 
> secondly, set the TDSDUMP environment variable (
> http://www.freetds.org/userguide/logging.htm ) and use the dump file to
> either solve the issue yourself, or post it to the list.
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds