Skip to content
  • Support@VoIPTools.com
  • +1 801 642 4655
  • 24/7 Support
Menu
  • Home
  • Tools
  • Downloads
  • Manuals
  • Hosting
  • Partners
  • Webinars
  • Contact Us
  • Blog
  • My Account
Purchase
Demos
×
Menu
  • Home
  • Tools
  • Downloads
  • Manuals
  • Hosting
  • Partners
  • Webinars
  • Contact Us
  • Blog
  • My Account

Tools - V18

  • Recording Manager V18
  • Audio Scheduler V18.0.39
  • Holiday Importer V18
  • 3CX Contacts Sync
  • 3CX Queue Notifier (Client) V18
  • Auto Voicemail V18
  • 3CX Barge Messages
  • Caller ID V18
  • Call Router V18
  • Competitive Wallboard V18
  • Custom Presence V18
  • Enhanced Billing Codes V18
  • Exporter V18
  • Hosted Billing V18
  • Monitor V18
  • On Call Manager V18
  • Emergency Notifier V18
  • Power Dialer V18
  • Profile Manager V18
  • Queue Notifier (Server) V18
  • Queues Wallboard V18
  • Reception Console V18
  • Recording Beep V18
  • Do Not Call V18
  • Recording Manager V18
  • Auto Call Back V18
  • Auto Self ID V18
  • Auto Logout V18
  • Auto Call Back V18
  • Surveyor V18
  • Audio Scheduler V18
  • Agent Greeting V18
  • Active Directory Sync V18
  • Survey Creator V18
  • Voicemail Manager V18
  • Wrapup Codes V18 (Server)
  • Click-to-Call V18
  • Holiday Importer V18
  • Wrapup Codes V18 (client)

Tools - V20

  • Caller ID V20
  • Auto Call Back V20
  • Active Directory Sync V20
  • Voicemail Manager V20
  • Survey Creator V20
  • Surveyor V20
  • Queues Wallboard V20
  • Audio Scheduler V20
  • Holiday Importer V20
  • AUTO LOGOUT V20
  • Enhanced Billing Codes V20
  • Power Dialer V20
  • Voicemail Manager V20
  • Monitor V20
  • Reception Console V20
  • Wrapup Codes Client V20
  • WrapUp Codes Server V20
  • Profile Manager V20
  • Hosted Billing V20
  • Exporter V20
  • Competitive Wallboard V20
  • 3CX CONTACTS SYNC V20
  • Auto Voicemail V20
  • Emergency Notifier V20
  • On Call Manager V20.0.2
  • Queue Notifier V20
  • Call Router V20
  • Custom Presence V20
  • Auto Self ID V20
  • RECORDING MANAGER V20

3CX Relay

  • VoIPTools Relay V20.0.22 (Windows)
  • VoIPTools Relay V20.0.22 (Linux)
  • VoIPTools Relay V20.0.21 (Windows)
  • VoIPTools Relay V20.0.21 (Linux)
  • VoIPTools Relay V20.0.20 (Windows)
  • VoIPTools Relay V20.0.20 (Linux)
  • Relay V18 (Linux) – Latest Relay 18.9.50
  • VoIPTools Relay V20.0.19 (Linux)
  • VoIPTools Relay V20.0.19 (Windows)
  • VoIPTools Relay V20 ( Windows)
  • VoIPTools Relay V20 ( Linux)
  • Relay (Windows) V18.4.35
  • Relay (Linux) V18.4.35
  • Relay V18 (Windows) – Latest Relay 18.9.56
  • Relay V18 (Linux) – Latest Relay 18.9.56
View Categories
  • Home
  • Docs
  • Configure SQL Server for Remote Access Over Internet

Configure SQL Server for Remote Access Over Internet

1 min read

Configure SQL Server to allow Remote Connections #

Follow the steps outlined below to configure SQL Server to permit remote connections.

1.Open SQL Management Studio

2. Right-click on the server and select Properties.

Figure 1: Right-Click Server: Properties

3. On the Connections tab check the Allow remote connections to this server

Figure 2: Connections: Allow remote connections to this server

4. Open SQL configuration utility SQL Server Configuration Manager.

Figure 3: Protocols for SQLEXPRESS: TCP/IP

5. In the SQL Server Network Configuration section, select Protocols for <your instance name>

6. Ensure TCP/IP is Enabled. To edit this setting, right-click and select Properties.

7. If necessary, change the “Enabled” setting to “Yes”.

8. Select the IP Address tab (same dialog in step 4 above)

Figure 4: TCP/IP Properties

9. Scroll down to section titled IPAll

10. Update TCP Dynamic Ports. It should be blank.

11. Update TCP Port. It should be 1433. 

12. Press OK to save changes. You will be prompted to restart the SQL service.

Figure 5: Warning message box

13. Select SQL Server Services

Figure 6: Restart SQL Server Services

14. Select SQL Server (<your instance name>)

15. Select Restart

16. To enable the SQL Server Browser service, right-click on the Service and select Properties

Figure 7: Enable SQL Server Browser Service

17. On the Properties screen select Start Mode and update the setting to Automatic

Figure 8: SQL Server Browser Properties

18. Start the SQL Server Browser

Figure 9: Start SQL Server Browser

Configure Windows Firewall to allow inbound traffic to SQL Server #

Follow the steps outlined below to configure the Windows firewall to allow inbound traffic to SQL Server.

1.If you are using the Windows firewall, you will need to open ports 1433 and 1434. Open the Windows Firewall

Figure 10: Open Windows Firewall

2. Select Advanced Settings

Figure 11: Advanced Settings

3. Create a new Inbound Rule by selecting Inbound Rules then New Rule

Figure 12: New Inbound Rule Wizard: Port

4. Select Port and Next

Figure 13: Specify the protocols and ports to which the rule applies

5. Select TCP and Specific local ports, then enter 1433

6. Choose Next to continue to the next screen

7. Select Allow the connection and choose Next

Figure 14: Specify the action

8. Select all three options and then press Next

Figure 15: Specify the profiles for which the rule applies

9. Give the rule a name and press Finish

Figure 16: Specify Name & Description of rule

10. Confirm you see the new inbound rule

Figure 17: New Inbound rule added

11. If you are using a named instance of SQL Server (Example: 192.168.5.30\SQLExpress) you will need to repeat these steps for port 1434 UDP

NOTE:

IMPORTANT! Port 1433 is TCP and 1434 is UDP

What are your Feelings
Still stuck? How can we help?

How can we help?

Updated on July 28, 2023

Powered by BetterDocs

Table of Contents
  • Configure SQL Server to allow Remote Connections
  • Configure Windows Firewall to allow inbound traffic to SQL Server
Logo - 3CX Platinum Partner
Logo - 3CX Advanced Certified

Navigation

  • Tools
  • Subscribe
  • Contact
  • Support
  • Product Downloads
  • Product Manuals
  • My Account
  • Partner Sign Up

Contact Us

  • Support@VoIPTools.com
  • Billing@VoIPTools.com
  • Live Chat
  • +1 801 642 4655
  • 4464 Glenwillow Dr. Batavia, OH 45103
Logo - 3CX Platinum Partner
Logo - 3CX Advanced Certified

COPYRIGHT © 2024 VOIPTOOLS. ALL RIGHTS RESERVED | PRIVACY | TERMS OF USE 

Cleantalk Pixel