IIS and SQL Server on diff computers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: linetlte (linette_at_wpro.who.int)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 19:05:47 +0800

hi,

we have this issue that when i use Integrated Windows Authentication, we
cannot access the sql server
it seems the user's credentials are not being passed on to the sql server
so for now, i use Basic Authentication but this prompts users for login

pls advise
thanks

regards,
linette

Relevant Pages

  • Delegation/Basic Authentication - using browsers other than IE
    ... I request a page that interfaces with SQL Server, since Integrated windows authentication won't work, it falls back on basic, I enter my credentials (yes I'm entering the right ones!), but get hit with these kind of errors. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: SQL 2K, IIS 5, ASP.NET
    ... What is the environment? ... Is it a domain or a workgroup? ... have set it as 'integrated windows authentication'. ... Q324479 ASP.NET SQL Server session state Impersonation Is Lost Under Load ...
    (microsoft.public.sqlserver.security)
  • 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)