"Sue Hoegemeier" wrote:

> A just plain "Login failed" error message indicates a bad
> user name/password. If there is more with the message,
> sometimes that can't help track it down. Turn on failed
> login audits in SQL Server to make sure you are getting the
> entire message. To turn it on, open Enterprise Manager,
> right click on the server and select properties. Go to the
> security tab and under Audit Level select Failed. Restart
> SQL Server. The failed logins will then be logged to the SQL
> Server logs.
> If you are getting a full error message of login failed for
> xyz. Not associated with a trusted SQL Server connection,
> then it means you are trying to use a SQL login but your
> server is only configured for Windows authentication. If you
> need to use SQL logins, change the Authentication to SQL
> Server and Windows. It's on the security tab of the
> properties for SQL Server.
> If you are trying to connect with Windows authentication,
> then in the connection string, don't supply a user name and
> password. Use Integrated Security=SSPI with an OLE DB
> provider in your connection string instead of supplying a
> username and password.
> You may want to change drivers that you are using. The OLE
> DB provider for ODBC is considered obsolete.
> You can find more on connection strings at:
> http://www.carlprothman.net/Default.aspx?tabid=81
>
> -Sue
>
> On Mon, 31 Oct 2005 14:55:06 -0800, "carlomd"
> <carlomd@discussions.microsoft.com> wrote:
>
> >Hi all, I'm new to SQL so here goes, we got a dbase we're putting up for the
> >web, and basically we're testing it out for connectivity, I set the system
> >dsn with the account that's in SQL server (got the server in mixed mode
> >auth), when I try to login to a page we put together I get this error
> >"Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> >[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'mitch'.
> >/ConnOpen.inc, line 10"
> >the username mitch exists in SQL server, the tests runs fine through
> >ODBC>system dsn. I looked all over the forums and can't find my issue or
> >anything similar, if anyone's seen this before, any pointers or ideas would
> >be great. Thanks
>