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

ID: Q222828

The information in this article applies to:

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.


  4. Select the radio button "With SLQ Server Authentication using a login ID and password entered by the user."


  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.


Additional query words: 


Keywords          : 
Version           : winnt:3.0
Platform          : winnt 
Issue type        : kbprb

Last Reviewed: March 26, 1999