freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Problem connecting to database

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Problem connecting to database
Date: Mon, 27 Oct 2008 23:32:46 -0400

Peter Ross wrote:
>
> I can connect using the user 'sa' but I cannot connect using the user
> 'MCTests' which I have defined myself.
> I can connect using 'MCTests' using ODBC from Windows Vista.
...
> I'm guessing it is actually a problem with the SQL server 2000
> configuration but I have got no ideas where to look.

Everything points to a server-side issue. The MCTests login is rejected
by the server after you send the login packet.

This is an ODBC connection. It may be that MCTests is not a user of his
default database. That could cause the server to reject the login. If
that's the issue, he'd be able to log in with tsql.

HTH.

--jkl

[freetds] Problem connecting to database, Peter Ross, 10/27/2008
- Re: [freetds] Problem connecting to database, James K. Lowden, 10/27/2008
  - Re: [freetds] Problem connecting to database, Peter Ross, 10/28/2008