Author: fha101 | Posted on: 10/21/2008 7:47:37 AM | Views : 271

 
Hi All,

We have a web server that is in our DMZ.  The web server is not on any domain as there is no Domain Controller in the DMZ.  It needs to talk to a SQL Server 2005 database that sits in a secure zone (call it the SZ) that is pat of a domain.  We would like he web server to use Windows autentiction to talk to the database, ideally having the web server log in to the SQL 2005 DB as a domain account from the SZ, but we cannot get this to work.  The only thing that works is creating a SQL account and passing the SQL BD username and password in the connection string contained in the web.config file.  How can we use windows authentication to permit the web server to talk the DB?

Cheers

 
...

Go to the complete details ...