Error connecting through the web

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
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
|||Thanks for the reply, it works now, I changed the username settings in a
config file that resides in inetpub and it worked, thanks again.
"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:
>
>