Home > Ask the Enterprise Desktop Experts > Questions & Answers > Problem accessing SQL Server using ASP.NET
Ask The Enterprise Desktop Expert: Questions & Answers
EMAIL THIS

Problem accessing SQL Server using ASP.NET

Roberta Bragg EXPERT RESPONSE FROM: Roberta Bragg

Pose a Question
Other Enterprise Desktop Categories
Meet all Enterprise Desktop Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 17 September 2004

My question is about frequent 680 and 529 events. We have a Web server running Win2K server that has the local user ASP.NET on it. This user is repeatedly trying to access resources on one of our SQL servers, which is running Win2K advanced server, causing the events to be generated. I have given information on the dates and times of the events coming from the SQL server to our Web team, but they can't figure out what is causing the problem. From what I could see, there are no drive mappings on the Web server to the SQL server or anything like that. Have you seen this type of thing before, or do you have any ideas what or how the ASP.NET user is trying to access the SQL server? Thanks for your time and your help. The events generated from the SQL server are as follows:

Event Type: Failure Audit
Event Source: Security
Event Category: Account Logon
Event ID: 680
Date: 9/8/2004
Time: 5:03:41 PM
User: NT AUTHORITYSYSTEM
Computer: SQL Server
Description:
Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
Logon account: ASPNET
Source Workstation: Web Server
Error Code: 0xC0000064


Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 9/8/2004
Time: 5:03:41 PM
User: NT AUTHORITYSYSTEM
Computer: SQL Server
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name: ASPNET
Domain: Web Server
Logon Type: 3
Logon Process: NtLmSsp
Authentication Package: NTLM
Workstation Name: Web Server
Caller User Name: -
Caller Domain: -
Caller Logon ID: -
Caller Process ID: -
Transited Services: -
Source Network Address:
Source Port: 0

>

By default ASP.NET applications use the ASP.NET account to access data. The SQL Server is not configured by default to allow access for this account to SQL databases and resources. Remember, file shares are not the only way to access data. WEB DAV, and Web servers can also be configured as part of an application that requires access to SQL data. Ask the Web team to look at ASP.NET applications that use the database and possible error messages that indicate failures.

If the ASP.NET account should be accessing data, then it can be configured to do so. Go to this link for more information. It's most likely that there is some process in the application that is attempting the access. Also, don't rule out an attempt by an attacker to use an ASP.NET application to attempt to obtain data by using it to run SQL queries.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Desktop Solutions - Windows for Enterprise
HomeTopicsITKnowledge ExchangeTipsMultimediaWhite PapersBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2008 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts