How can you compromise a SQL Server via Front-End Server ?

How can you compromise a SQL Server via Front-End Server ?

Secure Home | Search | About
 Microsoft Applications Security    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content add this group's latest topics to your Google content
Subject Author Date
How can you compromise a SQL Server via Front-End Server ? Marlon Brown 09-21-2005
Posted by Marlon Brown on September 21, 2005, 11:56 am
If you were  Registered and logged in, you could reply and use other advanced thread options
Imagine this:
I have a Sharepoint Front-End web server in the "Forest-Perimeter" network
(some call it DMZ).
Imagine the SQL server such Sharepoint server uses continues to be housed in
the "Internal" network. Therefore I would need to open a hole in the ISA
firewall to allow communication between the Sharepoint Front-End<----> SQL
Server (internal) network.

Can you tell me the mechanism and likelyhood of getting such SQL server
compromised via this Front-End web server ?
I know you can hit a SQL server pretty hard if you can explore SQL server
injections, but let's assume you use store procedures to avoid SQL server
injections.




Posted by =?Utf-8?B?T3pvbmU=?= on September 22, 2005, 3:25 pm
If you were  Registered and logged in, you could reply and use other advanced thread options
The only concern that I can see is if the SQL server actually has a Public IP
address on it. If it only has an internal / non-routable address, then you
should be pretty safe. If it has a private address on it, the only way to
get to the SQL server from the DMZ server would be to gain some type of
interactive access to the DMZ server... Just be sure that you are not
routing through the DMZ server to the backend network...

OR
if you have some port mapper program such as netcat on the DMZ server, this
would allow someone to punch through the DMZ server and connect to the
backend SQL server...

HTH
Ozone

"Marlon Brown" wrote:

> Imagine this:
> I have a Sharepoint Front-End web server in the "Forest-Perimeter" network
> (some call it DMZ).
> Imagine the SQL server such Sharepoint server uses continues to be housed in
> the "Internal" network. Therefore I would need to open a hole in the ISA
> firewall to allow communication between the Sharepoint Front-End<----> SQL
> Server (internal) network.
>
> Can you tell me the mechanism and likelyhood of getting such SQL server
> compromised via this Front-End web server ?
> I know you can hit a SQL server pretty hard if you can explore SQL server
> injections, but let's assume you use store procedures to avoid SQL server
> injections.
>
>
>
>

Posted by Jeff Cochran on September 25, 2005, 5:50 pm
If you were  Registered and logged in, you could reply and use other advanced thread options
wrote:

>Imagine this:
>I have a Sharepoint Front-End web server in the "Forest-Perimeter" network
>(some call it DMZ).
>Imagine the SQL server such Sharepoint server uses continues to be housed in
>the "Internal" network. Therefore I would need to open a hole in the ISA
>firewall to allow communication between the Sharepoint Front-End<----> SQL
>Server (internal) network.
>
>Can you tell me the mechanism and likelyhood of getting such SQL server
>compromised via this Front-End web server ?

Most common would be SQL injection.

>I know you can hit a SQL server pretty hard if you can explore SQL server
>injections, but let's assume you use store procedures to avoid SQL server
>injections.

Then should we also assume the SP's are invulnerable? :)

Of course, compromising the Sharepoint server and finding a connection
string with a password for the SA account would be a possibility as
well.

Jeff

Similar ThreadsPosted
Unable to request Server Authen. Certificate from CA for secondary IAS server March 7, 2007, 8:56 am
Updated critical patches and rebooted server (server did not reboo August 19, 2007, 12:32 am
how to configure Remote access server to log data to a SQL server May 31, 2006, 7:26 pm
Can not use UNC path in Windows server 2003 server 64 bit OS September 30, 2005, 4:19 pm
New to CA server service require reconfigure CA server- Please hel July 17, 2006, 12:00 am
Exchange server in DMZ, not FE server. Is this ever ok? June 10, 2007, 11:49 pm
FTP Server HELP!!! September 19, 2005, 7:37 pm
NEW CA Server January 14, 2007, 11:54 am
RE: SQL Server IIS ASP Set Up April 18, 2007, 8:21 am
Com server setup August 8, 2005, 5:39 am

The site map in XML format XML site map

Contact Us | Privacy Policy