Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem connecting to database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page