Article ID: 222828 - View products that this article applies to.
This article was previously published under Q222828
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:
Article ID: 222828 - Last Review: June 24, 2004 - Revision: 2.0
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.
Contact us for more help