Hello,

Can anyone guide me to information about best practices for implementing
authentication to an SQL server (domain member) from a Web Server (DMZ, not
a domain member) using windows authentication.

Thx

[ Post a follow-up to this message ]

What type of implementation?  Code, network-layer, transport security?

"David White" <David.White@verizon.be> wrote in message
news:OL6fhFAaEHA.3664@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> Can anyone guide me to information about best practices for implementing
> authentication to an SQL server (domain member) from a Web Server (DMZ,
not
> a domain member) using windows authentication.
>
> Thx
>
>

[ Post a follow-up to this message ]

On Mon, 12 Jul 2004 13:14:18 +0200, "David White"
<David.White@verizon.be> wrote:

>Can anyone guide me to information about best practices for implementing
>authentication to an SQL server (domain member) from a Web Server (DMZ, not
>a domain member) using windows authentication.

Well, best would be to use SQL Authentication...  

You have a number of issues here.  If it's a non-domain server, you
need a trust or other way to authenticate a domain user.  You will
also need to deal with Windows networking through your firewall.
Might want to start here:

HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
http://support.microsoft.com/defaul...b;en-us;q176379

Jeff

[ Post a follow-up to this message ]