Login failed for user 'MachineName\ASPNET'

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,
JasonLinda,
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
>
I have the same problem but I got it to work. Following information might
help:
ms-help://MS.MSDNQTR.2003FEB.1033/vbcon/html/vbtskAccessingSQLServerUsingWin
dowsIntegratedSecurity.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 wh
at
> 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...
>
>