Communication between SQL Server and IIS 6

Hello, I'm a newbie here, so please forgive me if the following seems a
little simplistic. My question concerns communication between SQL server
2005 (or SQL server 2000) and IIS 6, on separate boxes. There seems to be a
fair bit of comment, but little consensus from what I can find, on the best
way to achieve this and set it up. Can anyone help with this?
I am particularly confused, as Microsoft seem to recommend installing SQL
Server and IIS on separate boxes (as I have done), but there seems a great
deal of confusion as to how best get them communicating with one another.
If anyone has a definitive solution, I would be most grateful.
I am running Windows Server 2003 on all machines, and all boxes are on a
Network consisting of separate PCs for Domain Controller, SQL Server 2005,
and IIS 6.
--
Many Thanks,
kascommHello Kascomm,
If you use Windows auanthentication to connect to SQL server from IIS, you
need to enable delegation for IIS server. Please refer to the following
articles for details
810572.KB.EN-US HOW TO: Configure an ASP.NET Application for a Delegation
Scenario
http://support.microsoft.com/defaul...KB;EN-US;810572
817384.KB.EN-US HOWTO: Use Kerberos Authentication for Microsoft SQL Server
2000
http://support.microsoft.com/defaul...KB;EN-US;817384
More information
INF: Authentication Methods for Connections to SQL Server in Active Server
Pages
http://support.microsoft.com/defaul...kb;en-us;247931
PRB: "Client Unable to Establish Connection" Error Message When Connecting
from ASP to SQL Server
http://support.microsoft.com/defaul...kb;en-us;253500
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Communication between SQL Server and IIS 6
>thread-index: AcZcDqchB9YteuLzSI2gwzMRINj/Ew==
>X-WBNR-Posting-Host: 81.5.172.177
>From: examnotes <kascomm@.newsgroups.nospam>
>Subject: Communication between SQL Server and IIS 6
>Date: Sun, 9 Apr 2006 12:49:03 -0700
>Lines: 19
>Message-ID: <9ABAD085-5986-4061-9D63-3828549DA3CD@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.security
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:26988
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.security
>Hello, I'm a newbie here, so please forgive me if the following seems a
>little simplistic. My question concerns communication between SQL server
>2005 (or SQL server 2000) and IIS 6, on separate boxes. There seems to be
a
>fair bit of comment, but little consensus from what I can find, on the
best
>way to achieve this and set it up. Can anyone help with this?
>I am particularly confused, as Microsoft seem to recommend installing SQL
>Server and IIS on separate boxes (as I have done), but there seems a great
>deal of confusion as to how best get them communicating with one another.
>If anyone has a definitive solution, I would be most grateful.
>I am running Windows Server 2003 on all machines, and all boxes are on a
>Network consisting of separate PCs for Domain Controller, SQL Server 2005,
>and IIS 6.
>--
>Many Thanks,
>kascomm
>