cannot access website

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. Neither could Nerve. 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.

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
.

Relevant Pages

  • VSS Errors using NTBackup
    ... Microsoft OLE DB Provider for SQL Server ... Error message: ...
    (microsoft.public.windows.server.sbs)
  • sql server does not exist - urgent
    ... I have a sql server in the local network.I am able to connect to this ... server through my .net windows application using both dsnless and dsn ... connecting to this server.In this case while using dsn-less connection, ... and for dsn connection error message is ...
    (microsoft.public.sqlserver.connect)
  • Re: MySQL Access from SQL Server
    ... > Could not find server 'MSDASQL' in sysservers. ... The statement looks good to me, and it not result in any error message ... (You must set up the DSN on the server machine in such case. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • RE: Invalid authorization specification
    ... Does your application use a DSN to connect to SQL Server? ... DSN is setup correctly on the client machine. ... How to troubleshoot connectivity issues in SQL Server 2000 - ...
    (microsoft.public.sqlserver.connect)
  • Re: Programmatically create DSN usind SQL Server Authentication
    ... Not when you create the DSN programmatically. ... >Server using SQL Server Authentication. ... >is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)