Setting up SQL Server

Allowing the Keeper Gateway to access Microsoft SQL Server on port 1433

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*"

Last updated

Was this helpful?