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:06:04 -0400 (EDT)


Ok, what I'm asking is if you go into Enterprise Manager, right mouse
click on the server, then choose properties, and select the "Security" tab
does it have "SQL Server and NT Authentication" selected or just "Windows
NT Only" selected.

Brian

On 13 Jun 2001, 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..
>
> Any ideas?
> 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