Microsoft SQL Firewall & IP Settings

This post is a guide to Microsoft SQL Server Firewall & IP Settings.

INBOUND RULES TO SET

TCP

135 – SQL Transact Debugger/RPC

1433 – SQL Server Default Instance

1434 – SQL Server Admin Connection

2382 – SQL Server Browser

2383 – SQL Analysis Services

4022 – SQL Server Broker

UDP

1434 – SQL Server Browser Service

Make sure to setup the main IP Address to be used with the SQL Instance

on a Multi-Homed Dell Server

SQL Server Configuration Manager

SQL Server Network Configuration

Protocols for SQL Express

TCP/IP – Rt Click – Properties – Listen All to Yes

Select IP Addresses Tab

Select IP Address you want to use & Disable the rest

IPAll TCP Dynamic Port set to 49176/1433.

If IPAll used it takes precedence over all other.  Leave IPAll entries blank to allow use of individual IP (No Zero).

In IPAll put 49172/1433 in TCP Port if necessary

If IPALL above no work with 49176 & 49172, try 1312 & 1433

Restart SQL Services

Windoze Docs on SQL & Firewall

http://technet.microsoft.com/en-us/library/ms345318(v=sql.105).aspx

0 Comments

SQL & SQL Server Configuration

Microsoft SQL Server Express Firewall Port Setup

INBOUND RULES TO SET

TCP

135 – SQL Transact Debugger/RPC

1433 – SQL Server Default Instance

1434 – SQL Server Admin Connection

2382 – SQL Server Browser

2383 – SQL Analysis Services

4022 – SQL Server Broker

UDP

1434 – SQL Server Browser Service

Make sure to setup the main IP Address to be used with the SQL Instance

on a Multi-Homed Dell Server

SQL Server Configuration Manager

SQL Server Network Configuration

Protocols for SQL Express

TCP/IP – Rt Click – Properties – Listen All to Yes

Select IP Addresses Tab

Select IP Address you want to use & Disable the rest

IPAll TCP Dynamic Port set to 49176/1433.

If IPAll used it takes precedence over all other.  Leave IPAll entries blank to allow use of individual IP (No Zero).

In IPAll put 49172/1433 in TCP Port if necessary

If IPALL above no work with 49176 & 49172, try 1312 & 1433

Restart SQL Services

Windoze Docs on SQL & Firewall

http://technet.microsoft.com/en-us/library/ms345318(v=sql.105).aspx

 

0 Comments