double hop issue? Not sure anymore

Hi all

I have an issue which goes something like this

I have a web app that accesses a SQL Sever. I use AD for my users. In
SQL i have assigned my users to various roles etc....not SQL users but
AD users.

my web app uses identity impersonation = true and i have disabled
anonymous access in IIS

I have a development environment with XP, IIS5 and ver 1.1 of
framework. The web app works fine and shows my results.


I have a win2k server with IIS 5 on it and when i deploy my app to this
machine, which is part of the domain and IIS is configured the same
way, I get what seems to be the double hop issue. So i have ensured
that the anonymous access is diabled in IIS and integrated security is
turned on. the machine is part of the domain. I have installed the sql
client tools on the web server....no matter what i do i cannot access
SQL server...it keeps giving me the Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'. error. I checked the user name of the
person accessing the page by using
System.Security.Principal.WindowsIdentity.GetCurrent().Name and the
username is being written out however when this information passes to
SQL i still get the anonymous user error...

Can you please help me with this issue? I am really at a loss here...

Thank you.
Reeza

.

Relevant Pages

  • Re: Whats best practice for connecting to a Sql Server database
    ... I doubt you are moving to IIS 8 yet since IIS 7 is the version shipping in ... I generally prefer using Windows auth over SQL auth when possible ... that the web app ran under a user that had very weak rights and the ... connection string had the uname/pw to connect to the database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Tripled ADO Connections
    ... > The other day we turned off anonymous access in IIS 5.0 ... taking out the SQL Server. ... though all connections are now made in the context of the requesting user ... Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis.security)
  • Re: Website Administration Tool not working from published applica
    ... provider, whom most of them can't afford the fancy of dedicated servers - ... SQL Server 2000 instead of SQL Express ... The first mistake was using ... that the Web App Admin Tool shows when it cannot connect to the database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: double hop issue? Not sure anymore
    ... I have a web app that accesses a SQL Sever. ... The web app works fine and shows my results. ... this machine, which is part of the domain and IIS is configured the same way, I get what seems to be the double hop issue. ... So i have ensured that the anonymous access is diabled in IIS and integrated security is turned on. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Connection Error
    ... You can connect to SQL using Windows Auth, ... The reason is the web app is running under an account IUSR_YOURSERVERNAME that uses ASPNET account. ... I would however recommend creating a new SQL Server user and add it to the database you are connecting to. ...
    (microsoft.public.dotnet.framework.aspnet)