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 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
.
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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.
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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....
|
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
|
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...
|
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...
| |