# Setting up SQL Server

Below is the PowerShell commands to open up port 1433 on the SQL Server instance.

```
# Define the SQL Server port (default is 1433 for TCP)
$SQLPort = 1433

# Create a firewall rule for inbound SQL Server traffic (TCP)
New-NetFirewallRule -DisplayName "Allow SQL Server TCP" `
    -Direction Inbound -Protocol TCP -LocalPort $SQLPort `
    -Action Allow

# Allow SQL Server traffic on UDP port 1434 for SQL Browser service (optional)
New-NetFirewallRule -DisplayName "Allow SQL Server UDP" `
    -Direction Inbound -Protocol UDP -LocalPort 1434 `
    -Action Allow

# Verify the rules were created
Get-NetFirewallRule -DisplayName "Allow SQL Server*"
```