[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.
HTH.
--jkl
More information about the FreeTDS
mailing list