Re: Integrated Windows Authentication with Separate Server

From: Tom Kaminski [MVP] ((A_at_T))
Date: 07/28/03


Date: Mon, 28 Jul 2003 16:09:09 -0400


"howard" <oward@utvgroup.com> wrote in message
news:014101c3551e$76d31270$a101280a@phx.gbl...
> Is there a way to configure ASP.NET with IIS on one server
> and SQL on another server, using Integrated Windows
> Authentication, without using Impersonation, and not
> embedding any passwords in config files or anywhere
> else on the systems?
>
> It runs out of the box this way with IIS and SQL on the
> same machine. I just want to do the same thing when they
> are on different machines.

I can't think of any reason to do that. It just adds administrative
overhead and kills conneciton pooling. I believe it's basically the same
story as ASP.
http://support.microsoft.com/?id=176377
http://support.microsoft.com/?id=247931
http://support.microsoft.com/?id=810572

-- 
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/


Relevant Pages

  • FW: Microsoft Security Advisory MS 03-007
    ... am trying to find a vulnerability tester/script and I could test it out ... Department of the Army server that had been compromised and that this ... announcement covers IIS 5.1 but not IIS 6, ... How a Hacker Uses SQL Injection to Steal Your SQL Data! ...
    (Focus-Microsoft)
  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)
  • Re: SQL CE Synching Problems
    ... install location of SQL CE instead of under Inetpub like I had done before. ... > so the issue has to be between the server tools and the publisher. ... >>I ran the wizard again to check all the permissions and this is what it ... >> A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • 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)