Re: Problem connecting to database

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