Skip to Content.
Sympa Menu

freetds - Re: Troubles connecting to an MSSQL 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Troubles connecting to an MSSQL 2000
  • Date: Wed, 13 Jun 2001 18:18:50 -0400 (EDT)


Ok, your note was so thorough I missed this one. Did you specify a tds
version to use when you built freetds?

You configure line should contained either --with-tdsver=4.2 or
--with-tdsver=7.0 depending on whether you need large char types. (TDS 4.2
is a bit more mature, but doesn't support all of the newer features).

Brian

On 13 Jun 2001, Ruben Vandille wrote:

> On 13 Jun 2001 23:12:50 +0200, Ruben Vandille wrote:
> > On 13 Jun 2001 16:51:51 -0400, Brian Bruns wrote:
> > > Ruben,
> > >
> > > Make sure your server is set up for 'server logins' and not 'integrated
> > > security'. That could produce these symptoms.
> > >
> > I tried both a windows-user and an SQL-user ... both didn't work.
> >
> >
> >
> > I have indeed the same symptoms when mistype the password, or when I use
> > a non-existant user.
> >
> > So I looked in the logs of the SQL server and there I found this:
> > 2001-06-13 23:06:37.66 server Error: 17832, Severity: 20, State: 7
> > 2001-06-13 23:06:37.66 server Connection opened but invalid login
> > packet(s) sent. Connection closed.
>
> I found something in the microsoft knowledge base (!!!) about that
> error:
> http://support.microsoft.com/support/kb/articles/q239/8/83.asp
> pay attention to the note! (but I thought I saw something about a succes
> connecting to an SQL2000 server?!?)
>
> R.
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page