<div>
Create an access rule to allow (SQL port) tcp xxx, or udp xxx coming from the network/ip address you want to allow. &nbsp;It should look something like:<br />
access-list outside_access_in permit tcp ppp host xxx.xxx.xxx.xxx any eq ppp<br />
where ppp is the SQL port number(s).<br />
You also need to make sure you add the access list to the external interface.
</div>


<div>
<div class="content wysiwyg-content">
I have a PIX 506 firewall in front of a web and database server. &nbsp;I would like to permit access to the SQL port on all hosts on the inside for a single IP Address and deny for all others. &nbsp;How can i do this?
</div>
</div>


I have a PIX 506 firewall in front of a web and database server.  I would like to permit access to the SQL port on all hosts on the inside for a single IP Address and deny for all others.  How can i do this?

Create an access rule to allow (SQL port) tcp xxx, or udp xxx coming from the network/ip address you want to allow.  It should look something like:
access-list outside_access_in permit tcp ppp host xxx.xxx.xxx.xxx any eq ppp
where ppp is the SQL port number(s).
You also need to make sure you add the access list to the external interface.

PIX 506 - Allow Access by IP Address

A router is a networking device that forwards data packets between computer networks. Routers perform the "traffic directing" functions on the Internet. The most familiar type of routers are home and small office cable or DSL routers that simply pass data, such as web pages, email, IM, and videos between computers and the Internet. More sophisticated routers, such as enterprise routers, connect large business or ISP networks up to the powerful core routers that forward data at high speed along the optical fiber lines of the Internet backbone. Though routers are typically dedicated hardware devices, use of software-based routers has grown increasingly common.

Routers

Hardware-based firewalls provide more sophisticated protection for inbound and outbound traffic than the simple Windows software firewall or the basic NAT firewalls found in routers. These devices implement techniques such as stateful packet inspection, deep packet inspection, and content filtering; and may include built-in antivirus and anti-malware protection.

Hardware Firewalls

Software firewalls, also known as host-based firewalls, provide a layer of software on one host that controls network traffic in and out of that single machine. Most operating systems now include firewall software, but many available software firewalls include central distribution, antivirus systems and disaster recovery.