Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

Allowing remote connection to a SQL Server

Posted on February 23, 2021 By rich No Comments on Allowing remote connection to a SQL Server
From the SQL Server Configuration Manager:
1. Make sure that the TCP/IP protocol is enabled.
2. In the properties of the RCP/IP protocol, ensure that the IP address that clients are connecting to is “Enabled” and “Active”
3. Ensure that IPALL settings are 0 and 1433.
4. Ensure the following rules are setup in Windows Firewall:
Outbound TCP 1433-1434: Allow
Outbound TCP 1433-1434: Allow
Inbound UDP 1433-1434: Allow
Inbound UDP 1433-1434: Allow

Post navigation

❮ Previous Post: Setting up port forwarding on a Sonic Wall router
Next Post: Provisioning an Office 365 Tenant ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown