[freetds] Problem connecting to database
James K. Lowden
jklowden at freetds.org
Mon Oct 27 23:32:46 EDT 2008
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.
More information about the FreeTDS