Delegation not working, please help

From: p (abefuzzleduser2@yahoo.com)
Date: 08/13/02 

From: "p" <abefuzzleduser2@yahoo.com>
Date: Tue, 13 Aug 2002 12:23:06 -0500

We want to use windows 2000 User auth to query sql 2000 using security
groups that we have in place for an asp.net database page. I am trying to
setup delegation from iis to sql machine using integrated Auth. I have only
checked "Integrated Windows Auth" in IIS and have added this to web.config.
I have not added anything to the database since i thought it passes in the
entered credentials.
<authentication mode="Windows" />

<identity impersonate="true" />

The web page runs on my dev machine with iis local, db remote, probably
because I am am a domain admin. But when run the production IIS server I
keep getting the error after asking for and entering my domain login
information.
Index 0 is non-negative and below total rows count.
This error is when a databound textbox. I assume this means that there is
no data or dataset?

SQL Profiler shows that user="Anonymous Login" and login = "NT
authority/Anonymous Login" are trying to login to the database and fail. So
it looks like it is not sending my username to SQL ? Or does it login using
ASPNET and then pass the user credentials?

I could not add the ASPNET user to sql from that local acct on IIS machine.

Thanks
P

Relevant Pages

  • Login failure from asp.net delegation
    ... We want to use windows 2000 User auth to query sql 2000 using security ... checked "Integrated Windows Auth" in IIS and have added this to web.config. ... I have not added a login to the database since i thought it passes in the ...
    (microsoft.public.sqlserver.security)
  • 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: How to read data from stand alone SQL CE database on mobile device from VB.net 2005
    ... server running IIS to make the connection. ... the IIS requirement for SQL Server but I don't know. ... I have a stand alone SQL CE database on my windows mobile device. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server or IIS
    ... > user accounts to authenticate to SQL when they access the ... > database over the web. ... > is the database that locks them out or IIS. ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE on WIN2003 Server SBS
    ... I can connect to SQL. ... >> client I can't get a connection with NT Auth. ... folder where the database is located to read and write ... If I connect with SQL sa and sa-Pwd then the connection ...
    (microsoft.public.sqlserver.msde)