Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS + SQL Server 2000 SP3 problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS + SQL Server 2000 SP3 problem
  • Date: Wed, 18 Oct 2006 17:25:29 +0200

>
> Hi,
> I try to set up the connection with SQL Server and I get 'Login
> incorrect' messages. Logs in SQL Server show:
> """
> Error: 17832, Severity: 20, State: 7
> Connection opened but invalid login packet(s) sent. Connection
> closed..
> """
> Googling returns information (http://support.microsoft.com/kb/827422)
> about limiting access from third-party drivers. Is it a known
> issue? And
> am I going in good direction?
> I installed everything from packages (ubuntu-breeze):
> sqlrelay-freetds
> python2.3-sqlrelay
> I try to connect from python and manually built tsql
> (freetds-stable/0.64)
>
> Pawel
>

I'm able to connect to mssql2k up to SP4 and SQLExpress 2005 so I don't
think this is the problem. Probably you are trying to use an invalid tds
protocol.
For instance try with

TDSVER=8.0 ./tsql -H 123.4.5.6 -p your_port -U your_account -P
your_password

tsql -C

to get default compile TDS version

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page