[freetds] connecting to MSSQL 2005
James K. Lowden
jklowden at freetds.org
Sun Sep 7 12:14:49 EDT 2008
Jeremy Kister wrote:
> On 9/6/2008 11:27 PM, Jeremy Kister wrote:
> > I'm having a difficult time connecting to a mssql 2005 server.
> tsql reports:
> # tsql -S server -U dbun -P dbpw
> locale is "C"
> locale charset is "646"
> 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
Message 20009 indicates connect(2) failed. Either the server couldn't be
found, or it didn't respond to a connection request on the specified port.
I would use TDSDUMP to see the details of the connection attempt. If that
isn't enough, use TDSDUMPCONFIG to see how the servername is being
resolved to an IP address.
Also, you can bypass the whole lookup mechanism with:
$ TDSVER=7.0 tsql -H host -p port -U user -P passwd
More information about the FreeTDS