473,320 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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,
Jason
Nov 18 '05 #1
3 3604

Linda,

Have you looked at adding the following in your deny
users = "?" in the authorization section of your
web.config file

You can also get the NTLogin information of the logged
in user from User.Identity.Name property

Hope this helps
-----Original Message-----
I do not want to use Impersonation, and I do not want to add the ASPNETuser name to the SQL Server user accounts. I want a user to usewindows authentication to log into the site, and then have their ownspecific
credentials passed on to SQL Server, which will determine what accessrights that user has to the database.

I have seen this Microsoft article 316989
http://support.microsoft.com/default.aspx?kbid=316989, but it does notprovide a solution that meets my needs. If there is a way toprogrammatically override asp.net from providing the MachineName\ASPNET userto
SQL Server, please tell me!

Cheers,
Jason
.

Nov 18 '05 #2
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" <yw*******@yahoo.com> wrote in message
news:%2***************@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

Nov 18 '05 #3
I have the same problem but I got it to work. Following information might
help:
ms-help://MS.MSDNQTR.2003FEB.1033/vbcon/html/vbtskAccessingSQLServerUsingWindowsIntegratedSecur ity.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" <yw*******@yahoo.com> wrote in message
news:%2***************@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


Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Matthew Louden | last post by:
I wrote ASP.NET application that access SQL Server database. When I run the application, it yields "Login failed for user '<COMPUTER_NAME>\ASPNET'" error message. I then did the following, but...
4
by: rrober07 | last post by:
Hello, My Setup is I have a Web Server machine(Devweb01), Database SQL Machine(Devsql01), a Client Machine(local machine) I have configured the SQL machine as follows: 1) Added local Aspnet...
3
by: Maellic | last post by:
Hi, The website I am working on is built with ASP.NET and connects to a SQL Server 2000 database. The web server and database are on the same machine. I have recently tried to modify the timeout...
4
by: Chuck Bowling | last post by:
I'm having a problem that i really don't understand. I'm new to ASP.NET and to SQL Server (MSDE). I'm trying to get a VS walkthru in the C# to work. I think the problem is permissions but I'm not...
12
by: Michael | last post by:
Please Help me. I've got a .Net 2003 program that attaches to a SQL Server machine and I'm getting the above error when a user tries to log in. The SQL server is setup to use Windows Auth. and I...
5
by: Ramtin | last post by:
Hi; when I use sql server connection or ole connection for working with database I receive the login failed for user 'any user that I work'.I've been granted ASPNET user in sql.
10
by: BLUE | last post by:
I'm using SQL Server 2005 Developer Edition on Windows XP SP2 with this setting: <add name="SqlServerTrustedConn" providerName="System.Data.SqlClient" connectionString="Data...
11
by: Anil Gupte | last post by:
I am getting the following error: ********* Login failed for user 'AUM\ASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the...
4
by: RN1 | last post by:
I am working on WinXP Pro SP3, .NET 2.0 & SQL Server 2005 (Windows Authentication). When I run a ASPX page that connects to SQL Server, the following error gets generated: Login failed for user...
4
by: Brett | last post by:
I have an ASP.NET 2.0 application that uses Forms Authentication. The startup page contains just a login control, and the site works well on an IIS 6 web server. I am now setting the site up on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.