SYMPTOMS
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
CAUSE
The DSN used to connect to the Commerce database is misconfigured to use Windows NT security instead of SQL Server standard security.
WORKAROUND
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.