Re: asp.net sql trusted connections between servers

From: Rob (rob_at_nospamforme.com)
Date: 10/24/05

  • Next message: Charles Taylor: "2nd Attempt at an answer.please give my question a peek perhaps its an easy one for you..."
    Date: Mon, 24 Oct 2005 08:23:59 -0400
    
    

    Joe Kaplan (MVP - ADSI) wrote:
    > If IIS and SQL are on different boxes and you are using IWA in IIS, then you
    > need Kerberos delegation in order for IIS to be able to delegate the user's
    > credentials over a second machine hop to the SQL box.
    >
    > http://msdn.microsoft.com/vstudio/using/building/web/default.aspx?pull=/library/en-us/dnnetsec/html/SecNetHT05.asp?FRAME=true#ImplementKerberos
    > http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx
    >
    > Joe K.

    That seems to be the consensus. Thanks for the assistance. We'll be
    trying that this week.

    Rob


  • Next message: Charles Taylor: "2nd Attempt at an answer.please give my question a peek perhaps its an easy one for you..."

    Relevant Pages

    • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
      ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
      (microsoft.public.inetserver.iis.security)
    • RE: Co-Hosting SQL with IIS FTP service
      ... there are no functional conflicts between SQL and IIS; their network resource demands are unique. ... If the machine resources are enough, you can also use your favorite virtualization technology to separate the FTP and SQL servers and thus avoid the combinational security issues that public FTP services may impose on the SQL server. ... Co-Hosting SQL with IIS FTP service ...
      (Focus-Microsoft)
    • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
      ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... check the local computer - so there are no FW or Gateway problems. ... SQL Hi, I get the following error message when I try ...
      (Focus-Microsoft)
    • Re: General Network Error - MS Stumped
      ... > environment between our ASP.NET application and SQL Server 2000. ... > to be related to queries that return "large" amounts of data from SQL. ... > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS ... > at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ...
      (microsoft.public.sqlserver.connect)
    • Re: General Network Error - MS Stumped
      ... > environment between our ASP.NET application and SQL Server 2000. ... > to be related to queries that return "large" amounts of data from SQL. ... > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS ... > at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ...
      (microsoft.public.sqlserver.server)