Re: Login failed for user 'MachineName\ASPNET'

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

From: S. Justin Gengo (sjgengo_at_aboutfortunate[no-spam)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 08:30:10 -0500

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

  • 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)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... Is the SQL server box in the same domain as the web server (or do they have ... went wrong with your impersonation. ... > I have a local webservice and I was to use to access a SQL server on their ... > of the domain user in the web.config. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Permission required to execute a DTS package from ASP.NET applicatio?!!
    ... Yes,I've enabled impersonation in my application and that's why it is under ... > does SQL server is on the same server as your ASP.net application? ... >> I'm calling a DTS package from my asp.net application.Apparently because ... >> of the current security context and it is my Domian user name and I'm ...
    (microsoft.public.sqlserver.dts)
  • RE: Connect to database after windows impersonation.
    ... I would turn on Profiler with a filter to look at the particular database. ... > has admin rights on the SQL server box and the SQL Server itself. ... > //do the impersonation by calling am method in the class Impersonation I ... > specify a SQL Login in the connectioon string, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login failed for user MachineNameASPNET
    ... > Or is your SQL Server not on the same network? ... > Really impersonation is the best way, but I do remember a Visual Studio ... >> windows authentication to log into the site, ... >> programmatically override asp.net from providing the MachineName\ASPNET ...
    (microsoft.public.dotnet.framework.aspnet)