Re: Server Error in '/MyWebForm' Application

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Greg Burns (greg_burns_at_DONT_SPAM_ME_hotmail.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 13:46:55 -0400

> login failed for user 'DELL340\ASPNET'.

Sounds like the ASPNET account, the account ASP.NET pages run under by
default, doesn't have access to your database.

> Login failed for user 'DELL340\IUSR_DELL340'.
>
> How come the user changed and where did the user name come from?
>

IUSR_<COMPUTER NAME> is the account IIS is running under. It switched to
that account because you added <identity impersonate="true" /> to your
web.config. And presumably, you left anonymous access checked in IIS
security settings for your virtual directory.

Is SQL server installed on your computer, or on a remote computer? If it is
local, then you need to give ASPNET rights to the database using SQL
Enterpise Manager.

If SQL is remote, then things get stickier, but let us know first...

HTH,
Greg

"Edward Mitchell" <emitchell@nospam.ieee.org> wrote in message
news:uonLpFBnEHA.3684@TK2MSFTNGP10.phx.gbl...
>I have a problem that involves the error I receive when attempting to
>complete the asp.net web application example (Walkthrough: Creating a Web
>Application Using a Third-Party Business Object). When I first create the
>SQL connection in VS.NET 2003, I test the connection and everything works
>fine. However, when I attempt to run the first stage of the app (the bound
>datagrid), I receive an error stating:
>
> login failed for user 'DELL340\ASPNET'.
>
> There was another post in this newsgroup on this subject (Difficulty
> connecting to SQL Server 2000:2002-03-04) that suggested placing the line:
>
> <identity impersonate="true" />
>
> in the Web.config file but when I run the app again, there is the
> following failure message:
>
> Login failed for user 'DELL340\IUSR_DELL340'.
>
> How come the user changed and where did the user name come from?
>
> What can I do to fix the problem?
>
> I appended the full text of the second error message. System is Windows
> XP, SP2. MSDE server.
>
> Ed.
> --
> Edward E.L. Mitchell
> Web: www.racesail.org
> Phone: (508)771-0806
> 500 Ocean St., Unit 134,
> Hyannis, MA 02601
>
>
>
> Server Error in '/MyWebForm' Application.
> --------------------------------------------------------------------------------
>
> Login failed for user 'DELL340\IUSR_DELL340'.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Login failed for
> user 'DELL340\IUSR_DELL340'.
>
> Source Error:
>
> Line 48: public void FillDataSet(myDataSet dSet)
> Line 49: {
> Line 50: sqlDataAdapter1.Fill(dSet);
> Line 51: }
> Line 52:
>
> Source File: c:\inetpub\wwwroot\mywebform\component1.cs Line: 50
>
> Stack Trace:
>
> [SqlException: Login failed for user 'DELL340\IUSR_DELL340'.]
> System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction) +472
>
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> options, Boolean& isInTransaction) +372
> System.Data.SqlClient.SqlConnection.Open() +384
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
> ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +304
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +77
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
> MyWebForm.Component1.FillDataSet(myDataSet dSet) in
> c:\inetpub\wwwroot\mywebform\component1.cs:50
> MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\mywebform\webform1.aspx.cs:27
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +731
>
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET Version:1.1.4322.573
>

Relevant Pages

  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 express security issue
    ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ... You do not have to use the "sa" account and it's not recommended using this account because every hacker knows that SQL Server has a built-in sysadmin account which is called "sa". ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express security issue
    ... Ekrem Onsoy ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.NET, Win2k, SQL 2k on an intranet (w/Kerberos?)
    ... In your place I would go trough database and have mirrored accounts in SQL ... you can create views on SQL server to filter out ... Grant ASPNET account logon rights to SQL server and limit ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Problem connecting to SQL2000...
    ... problems with their current sql installation. ... >Install without database engine (that way you could ... >account is the database access account. ... >Microsoft MVP - SharePoint Portal Server ...
    (microsoft.public.sharepoint.portalserver)