Err Msg: Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d'

Article translations Article translations
Article ID: 222828 - View products that this article applies to.
This article was previously published under Q222828
Expand all | Collapse all


When you try to shop a Commerce site, an error similar to the following occurs:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User:
Reason: Not defined as a valid user of a trusted SQL Server connection.
/storename/i_shop.asp, line 73


The DSN used to connect to the Commerce database is misconfigured to use Windows NT security instead of SQL Server standard security.


Change the DSN to use SQL Server standard security:
  1. In Control Panel, open the ODBC Data Source Administrator.
  2. On the System DSN tab, select the appropriate DSN and click Configure.
  3. Click Next in the Microsoft SQL Server DSN Configuration dialog box.
  4. Select With SQL Authentication using a login ID and password entered by the user radio.
  5. In the Login ID field, enter the appropriate SQL Server Login ID. For example: sa.
  6. In the Password field, enter the password associated with the Login ID, and then click Next.
  7. Click Next twice.
  8. Click Finish.
  9. Click Test Data Source to ensure that the DSN is configured properly.
  10. Click OK.
  11. Click OK.
  12. Click OK.


Article ID: 222828 - Last Review: June 24, 2004 - Revision: 2.0
  • Microsoft Site Server 3.0 Commerce Edition
kbprb KB222828
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from