IT:AD:SQL Server:HowTo:Install

I don't do this enough to remember anything in between installs:

Installing using NETWORK SERVICES

–

List of Ports Required for SQLServer: MSDN
- TCP 1433 (as defined by the IT:AD:IANA:)
- UDP 1434
MSDN Reference
Configuration of Firewall: IT:AD:Firewall

Configuration of Firewall, using netsh (I think this is only still needed for systems older than vista and WS2K8)

netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT

Configuration of Advanced Firewall, using netsh

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

Process