connection between data server and web server

[Prudhvi Reddy]

Hi guys

I have 2 windows 2000 servers. One is a web server ( asp pages ) connected
to the public side of my router and the other one is
a database server ( SQL server ) which is connected to this web server.

I want to have my database server ( SQL server) secure, I want it to allow
connections only from my web server. In other words the link between
my web server and database server should have only sql traffic. Can this be
done by RRAS of Windows 2000 server?

Thanks
Reddy

 

[Jeff Cochran]

I have 2 windows 2000 servers. One is a web server ( asp pages ) connected
to the public side of my router and the other one is
a database server ( SQL server ) which is connected to this web server.

I want to have my database server ( SQL server) secure, I want it to allow
connections only from my web server. In other words the link between
my web server and database server should have only sql traffic. Can this be
done by RRAS of Windows 2000 server?

Might look at:

HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379

Jeff

 

[Phillip Windell]

HOWTO: IIS and SQL Server on Separate Machines with Trusted
Connection:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379

Hey Jeff,
I was reading through that article and one that it links to and noticed that
they didn't mention IPSec. Could IPSec be used in a case like that, or
would IIS or the SQL Server have some kind of problem with it?