NEW LOCATION

Olá Brazil Brazil NVMe-powered VPS Plans in Brazil Now Available.

Deploy Instantly
  • +357 2425 0808
  • Login
  • English

Home

Blog

How To Enable Remote Connections to SQL ...

How To Enable Remote Connections to SQL Server

How To Enable Remote Connections to SQL Server

NetShop ISP

NetShop ISP · Blog Author

Mar 27, 2023 · Technical Tutorials

In this article we will demonstrate the exact steps you need to perform to allow remote connections to your SQL Server. This is useful if you want to execute queries from a remote computer or connect a remote web server to your SQL Instance.

Pre-requisites

  • RDP is enabled on the Windows Server
  • SQL Server (Express, Web, Standard or Enterprise) installed
  • You have Administrator-level access on Windows Server
  • You have at least one user created with Database Connect access on SQL Instance

Steps to Enable Remote Connections to SQL Server

Step 1: Configure SQL Server Management Studio for Remote Connections

1.1. Click Start and search for SQL Server Management Studio
1.2. Connect to your SQL server instance
1.3. From the left navigation menu, right-click the server name and click Properties
1.4. Go to the Security page for Server Authentication, and select SQL Server and Windows Authentication mode

1.5. Go to the Connections page and tick/enable Allow remote connections to this server. Then click OK

Since we have completed all steps to enable remote connections to the SQL Server, last thing we need to do is to ensure that the Windows Firewall (if enabled) can accept the incoming connections to the server.

Step 2: Configure Windows Firewall for SQL Server Remote Connections

2.1. Click Start and search for Windows Defender Firewall with Advanced Security
2.2. Click on Inbound rules
2.3. Click New Rule from the Actions menu (right side)
2.4. Select Port and click Next
2.5. Select TCP and then enter the Specific Port which is for MSSQL Server: 1433
2.6. Action: Select Allow the Connection and click Next
2.7. Enter a name for this new rule and click Finish

At this point we need to create one more Inbound rule as follows:
2.8. Click on Inbound Rules and then click New Rule
2.9. Select Custom and click Next.
2.10. Click the Customize button from the Services section
2.11. Select Apply to this service and select your SQL Server. Then click OK.
2.12. Continue by clicking Next all the way through. Finally, create a Name of this New Rule. Then click Finish

Step 3: Configure TCP/IP in SQL Server Configuration Manager

3.1. Go to Start and search for SQL Server Configuration Manager
3.2. Expand SQL Server Network Configuration and Protocols for your Server (you will see your server’s name there).
3.3. Right-click TCP/IP and select Enable.

3.4. Right-click TCP/IP again and select Properties. View the IP Addresses tab and locate IPAll
3.5. Enter the value 1433 directly in the TCP Port field and click OK to apply the change

3.6. Finally, you need to restart your SQL Server for the above change to take effect. From the SQL Server Services dialog, right-click on your server name and click Restart

Get peace of mind with Managed SQL Server Hosting

Managed SQL Hosting is a value-added service offered by NetShop ISP where we take care of everything related to your SQL Database(s); from initial SQL Server installation, fine-tuning for best performance, on-going administration and 24×7 pro-active monitoring.

Contact us today to arrange a 1:1 consultation by one of our SQL Server specialists.

Press Releases
75

Free VPS Trial

No Credit Card Required.

Recent Posts

The Importance of Server Backups: Ensuring Data Security and Business Continuity

The Importance of Server Backups: Ensuring Data Security and Business Continuity

24 September, 2024

The Critical Role of Server Time Synchronization in MetaTrader 5 (MT5) Cluster

The Critical Role of Server Time Synchronization in MetaTrader 5 (MT5) Cluster

04 September, 2024

NetShop ISP Expands Global Cloud Footprint in São Paulo, Brazil (LatAm)

NetShop ISP Expands Global Cloud Footprint in São Paulo, Brazil (LatAm)

30 August, 2024

Microsoft Security Alert: Zero-Click IPv6 Vulnerability on Windows Servers [CVE-2024-38063]

Microsoft Security Alert: Zero-Click IPv6 Vulnerability on Windows Servers [CVE-2024-38063]

17 August, 2024

How To Connect (RDP) on Windows Server 2022 from Linux Ubuntu PC

How To Connect (RDP) on Windows Server 2022 from Linux Ubuntu PC

16 August, 2024

#letushostyou

Award Winning Hosting Provider established in 2004.

120 Faneromenis Avenue, Imperial Tower, 2nd Floor, Larnaca 6031, Cyprus

Products

Bare Metal Servers

Customized Servers

Virtual / Cloud Servers

Forex VPS

Storage VPS

cPanel Web Hosting

Reseller Web Hosting

Colocation

Addons

Premium DNS

Email Hosting

Cloud Backup

DDoS Protection

Licenses

SSL Certificates

Domain Names

Premium SLAs

About Us

Data Center Locations

Looking Glass

Our Company

Contact Us

Careers in Cyprus

Become a Partner

Awards

Certifications

© 2024 S.S. NetShop Internet Services Ltd. All rights reserved.  Terms & Conditions  |  Privacy Policy
CY Reg. Number: HE 217340 | EU VAT Number: CY10217340J

Visa
Mastercard
PayPal
Bitcoin
Tether
Ethereum
Litecoin
Wise
Revolut
Wire Transfer