IWA and Anonymous Access



Hello ,
I am trying to solve pretty straight forward and typical task and yet have
difficulties. Can someone help ? I cannot believe this has not been solved
by someone already.

I have simple ASP.NET intranet app which is supposed to record user's
windows username into the SQL database.

Database administrators granted permissions to single dedicated windows
account to read/write the db and enforced the rule that only windows
authentication to SQL db is allowed.

Now comes the problem:

If I enable anonymous access in IIS and put that dedicated account on, I can
read/write SQL db, but userid detected by my ASP code is always blank.

If I disable anonymous access, then userid is not blank, but I cannot
read/write SQL db because only dedicated account has permissions, not users
themselves.

What I really need is both: ability to programmatically detect username and
ability to use windows authentication with SQL db.

Any ideas ?

Thanks
VT


.



Relevant Pages

  • Windows Impersonation authentication to SQL Server?
    ... Impersonation will each Windows Domain user accounts need to be granted ... all be tracked and displayed in SQL Profiler? ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication to SQL Server?
    ... oranges in trying to convert an asp.net app which uses forms authentication ... mode throughout the app with one SQL login account into SQL Server versus ... converting the asp.net app into a full individual Windows authentication ... Ultimate goal would be to see the individual windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • [TOOL] Resources for Combating the Slammer Worm
    ... installations of Microsoft® SQL Server™ and the Microsoft SQL Server ... SQL Server 2000 SQL Scan Tool ... runs on computers running Windows 2000 or higher and can identify ... Check runs on computers running Windows 98, Windows ME, Windows NT 4.0, ...
    (Securiteam)
  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... connection but unless you're good at setting up groups/schema/logins/users, ... Windows auth is slower as the domain must ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... windows user that they aren't running this code? ... > SQL Scan will scan a computer, a domain or a range of IP addresses. ... > Jerry Bryant - MCSE, ... > rights. ...
    (microsoft.public.security)