Re: SQL Server & IIS

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 04/25/03

  • Next message: Marc: "Desktop Engine User Login" 
    Date: Fri, 25 Apr 2003 19:58:09 +0100

    Do you want to use delegation to pass the client
    credentials ? If SQL and IIS are on separate
    servers then have a look at
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT05.asp 

    -- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mark" <mtaylor@globalsolar.com> wrote in message
news:01de01c30b55$64830660$a101280a@phx.gbl...
> Can someone tell me how to set up IIS so that it
> communicates with SQL Server without passing an anonymous
> User ID and Password?  I have posted this question in both
> the SQL Server and IIS forums.  Your assistance is greatly
> appreciated.  By the way, I have turned off Anonymous
> Access for the website and turned on Windows Integrated
> Security.  I am able to get a db connection for myself
> because I am signed on to the server.
  • Next message: Marc: "Desktop Engine User Login"

    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)