Re: cannot connect with tsql

Kevin Reed wrote:
> tsql -H [ip address] -p 5000 -U uname -P password
> 
> returns:
> ocale is "en_CA.UTF-8"
> locale charset is "UTF-8"
> Msg 20017, Level 9, State -1, Server OpenClient, Line -1
> Unexpected EOF from the server
> Msg 20002, Level 9, State -1, Server OpenClient, Line -1
> Adaptive Server connection failed
> There was a problem connecting to the server
> 
> 
> is this a security problem on the SQL server side or something  

http://www.freetds.org/userguide/serverthere.htm

Set the TDSVER environment variable to the version you need, per the
example.  It's not a permission problem.  The server is dropping the
connection because the login packet is malformed, i.e., not what it's
expecting.  

HTH.  

--jkl