More Tips and Troubleshooting Help for Classic ASP Developers

re: More Tips and Troubleshooting Help for Classic ASP Developers

Bret Bentzinger — Fri, 13 Mar 2009 17:01:21 GMT

This error 80040e4d means that the database refused the connection due to ACCESS DENIED. So the actual user tring to connect to the database, does not have permissions to do so. In this case it looks like the user is NT AUTHORITY\IUSR for the thread making the call, and it doesn't look like a username and password is passed in to the connection string. So unless the database e2mdev allows everyone and Anonymous access that call will fail. I would doublecheck the security on the e2mdev database, and then make sure you are connecting as someone with access.

re: More Tips and Troubleshooting Help for Classic ASP Developers

Anonymous — Fri, 13 Mar 2009 10:27:18 GMT

our server is migrated to (windows 2008/sql2008/iis7) it throws error error '80040e4d' while connecting database, i enabled Failed Request Tracing.

The error log as below

Url 83.244.197.221/.../index.asp

App Pool DefaultAppPool

Authentication anonymous

User from token NT AUTHORITY\IUSR

Activity ID {00000000-0000-0000-3100-0080000000F2}

Site 1

Process 4652

Failure Reason STATUS_CODE

Trigger Status 500

Final Status 500

Time Taken 47 msec

ASP_LOG_ERROR

LineNumber 24

ErrorCode 80040e4d

Description

WARNINGS

ModuleName IsapiModule

Notification 128

HttpStatus 500

HttpReason Internal Server Error

HttpSubStatus 0

ErrorCode 0

ConfigExceptionInfo

Notification EXECUTE_REQUEST_HANDLER

ErrorCode The operation completed successfully. (0x0)

and my database connection classic ASP code is as below

Dim rsUSERSESSIONEXISTS

set rsUSERSESSIONEXISTS = Server.CreateObject("ADODB.Recordset")

rsUSERSESSIONEXISTS.ActiveConnection = "Driver={SQL Server};Server=" & Request.ServerVariables("LOCAL_ADDR") & ";Database=e2mdev"

rsUSERSESSIONEXISTS.Source = "SELECT * FROM userinfo_userinfo"

rsUSERSESSIONEXISTS.CursorType = 0

rsUSERSESSIONEXISTS.CursorLocation = 2

rsUSERSESSIONEXISTS.LockType = 3

rsUSERSESSIONEXISTS.Open()

rsUSERSESSIONEXISTS_numRows = 0

please help me

March 2009 - Technical Rollup Mail - Internet

Technical RollUp — Tue, 10 Mar 2009 22:32:43 GMT

News Biztalk Server New Case Studies Saiseikai Kumamoto Hospital - Japanese Regional Hospital Boosts

More Tips and Troubleshooting Help for Classic ASP Developers

Web Development Community — Tue, 10 Mar 2009 11:00:02 GMT

You are voted (great) - Trackback from Web Development Community

More Tips and Troubleshooting Help for Classic ASP Developers …

More Tips and Troubleshooting Help for Classic ASP Developers … — Sat, 21 Feb 2009 05:00:17 GMT

Pingback from More Tips and Troubleshooting Help for Classic ASP Developers …

Windows Vista » More Tips and Troubleshooting Help for Classic ASP Developers

Windows Vista » More Tips and Troubleshooting Help for Classic ASP Developers — Sat, 21 Feb 2009 03:14:20 GMT

Pingback from Windows Vista » More Tips and Troubleshooting Help for Classic ASP Developers

Webmaster Crap » Blog Archive » More Tips and Troubleshooting Help for Classic ASP Developers …

Sat, 21 Feb 2009 01:35:16 GMT

Pingback from Webmaster Crap » Blog Archive » More Tips and Troubleshooting Help for Classic ASP Developers …