Re: Login failed for user 'MachineName\ASPNET'

From: Paul (Paul_at_discussions.microsoft.com)
Date: 10/24/04 

Date: Sat, 23 Oct 2004 23:25:04 -0700

I have the same problem but I got it to work. Following information might
help:

ms-help://MS.MSDNQTR.2003FEB.1033/vbcon/html/vbtskAccessingSQLServerUsingWindowsIntegratedSecurity.htm

Paul

"S. Justin Gengo" wrote:

> Linda,
>
> If you are using Windows Authentication for the site, why not use
> impersonation?
>
> That would solve your problem because it would automatically sync up the
> user accounts.
>
> Or is your SQL Server not on the same network?
>
> Really impersonation is the best way, but I do remember a Visual Studio
> Magazine article on how to impersonate a user selectively. I think it's what
> you need:
>
> www.visualstudiomagazine.com top right of page enter locator + code:
> VS0405QA_T
>
> --
> Sincerely,
>
> S. Justin Gengo, MCP
> Web Developer / Programmer
>
> www.aboutfortunate.com
>
> "Out of chaos comes order."
> Nietzsche
> "Linda" <ywang2009@yahoo.com> wrote in message
> news:%23fp3FqFhEHA.596@TK2MSFTNGP11.phx.gbl...
> >I do not want to use Impersonation, and I do not want to add the ASPNET
> > user name to the SQL Server user accounts. I want a user to use
> > windows authentication to log into the site, and then have their own
> > specific
> > credentials passed on to SQL Server, which will determine what access
> > rights that user has to the database.
> >
> > I have seen this Microsoft article 316989
> > http://support.microsoft.com/default.aspx?kbid=316989, but it does not
> > provide a solution that meets my needs. If there is a way to
> > programmatically override asp.net from providing the MachineName\ASPNET
> > user
> > to
> > SQL Server, please tell me!
> >
> > Cheers,
> > Jason
> >
> >
>
>
>

Relevant Pages

  • Re: Login failed for user MachineNameASPNET
    ... If you are using Windows Authentication for the site, ... Or is your SQL Server not on the same network? ... Really impersonation is the best way, but I do remember a Visual Studio ... > user name to the SQL Server user accounts. ...
    (microsoft.public.dotnet.framework.aspnet)
  • how to hash impersonated password
    ... We're going to use impersonation in our web.config file to connect via ... windows authentication to a SQL Server on the same domain. ... hash the password rather than store it in plain text in the web.config file ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Problem With Web Service
    ... Do you use windows authentication for connecting to the sql server? ... Do you use impersonation in the web application? ... If the web service is implemented in a different project and you use windows ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)