RE: SQL 2K, IIS 5, ASP.NET

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 08/15/02 

From: lideng@online.microsoft.com (linda deng[MS])
Date: Thu, 15 Aug 2002 06:21:40 GMT

Hi HKarp,

Before we go any further, I would like to confirm some details with you.
What is the environment? Is it a domain or a workgroup? How did the IIS
server configure? Did it configured as the 'anonymous access', 'basic
authentication' or 'integrated windows authentication'? It seems that you
have set it as 'integrated windows authentication'. What account did you
logon on to the client?

The following KB articles Q247931 INF: Authentication Methods for
Connections to SQL Server in Active Server Pages
(http://support.microsoft.com/default.aspx?scid=kb;[LN];Q247931) and
Q324479 ASP.NET SQL Server session state Impersonation Is Lost Under Load
(http://support.microsoft.com/default.aspx?scid=kb;[LN];Q324479). If
anything is unclear, please let me know.

Sincerely,

Linda Deng
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: IIS & SQL Issues
    ... It's called the "double hop" issue and happens if the SQL Server is not on ... Here is one article on it, search google for "double hop" and you should get ... > integrated Windows authentication. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: using login credentials for HTTPwebrequest basic/digest authen
    ... I thought that when you mentioned you wanted to use Digest that you would know the username and password. ... In your local IIS go to the security settings and uncheck anonymous access and check integrated windows authentication. ... The only thing that have been an issue is to setup delegation between the web server and sql server when located on different servers and you want to login with the same credentials on the sql server. ...
    (microsoft.public.dotnet.framework)
  • ASP.NET Win2K and WinXP login problems
    ... >, Exchange, SQL Server and sharepoint running on it. ... Login, passwd and domain. ... uncheck "show friendly url" ... >Integrated Windows authentication - checked ...
    (microsoft.public.inetserver.iis)
  • Re: ADSI - Authenticating Users
    ... I have a webapp where I have all user data in my sql server, ... That means I use anonymous access. ... I have also checked the Integrated windows authentication. ... upload pictures to a folder. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... I am in an environment where bulk insert isn't an option--even though the ... underlying database is SQL server, I am using a third party OLE DB provider-- ... > insert(assuming you are using SQL server) or DTS. ...
    (microsoft.public.data.ado)