[mightbefake]

Hi- I keep getting the following error message when trying to log onto Nerve.com--this started a few weeks ago; I do not get the error message on other sites that require a log-in. I have not added any new software to my computer. I am running PC-Cillin -have already contacted their help desk , but its not a problem with their program (I still cannot log on even after disabling the PC-cillin). Problem occurs on my Dell laptop- Dell tech support couldn't help me. here is the error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'rex2'.

/includes/connection.asp, line 12



I have no clue who or what rex2 is.

thanks in advance.

[Advertisements]

Looks to be a problem on their end.

[admin]

Looks to be a problem on their end.

[mightbefake]

if by "their" you mean the folks at the Nerve website, I have already contacted them and they do not have a clue.

I googled "error '80040e4d" and came up with several hits with solutions that I can't quite get a handle on as directions do not seem intended for XP system, including this one (which i've picked because it says something about an e-commerce site and I am trying to accces a log-in page --I can open the initial page for the site with no problem)


Err Msg: Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d'
View products that this article applies to.
Article ID : 222828
Last Review : June 24, 2004
Revision : 1.0
This article was previously published under Q222828
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.
APPLIES TO
• Microsoft Site Server 3.0 Commerce Edition