Configure SQL Server to allow remote connections on port 1433

preview_player
Показать описание
Configure SQL Server to allow remote connections on port 1433

1. Prepare

- DC16, DC17 : SQL Servers, IP 10.0.0.16, 10.0.0.17

2. Step by step : Configure SQL Server to allow remote connections on port 1433

- DC16 : Using SQL Server Management Studio remote connections to DC17 on port 1433

+ Start - SQL Server Management Studio - Server name : DC17 - Connect === Cannot connect to DC17

+ Start - cmd - telnet 10.0.0.17 1433 === Connect Failed

- DC17 : Configure SQL Server to allow remote connections on port 1433

+ Start - SQL Server Configuration Manager - SQL Server Network Configuration - Protocols for MSSQLSERVER

- Right-click TCP/IP : Enable - Properties - IP Addresses tab - Set IPs, TCP Port : 1433

- DC16 : Connect again

+ Start - cmd - telnet 10.0.0.17 1433 === OK

+ Start - SQL Server Management Studio - Server name : DC17 - Connect === OK
  1. microsoft lab
Рекомендации по теме
How to Enable 0:04:12

How to Enable Network Access in SQL Server Configuration Manager | FoxLearn

How to Configure 0:06:12

How to Configure Remote Access and Connect to a Remote SQL Server 2019? | MilesWeb

Configure the Windows 0:03:43

Configure the Windows Firewall to Allow SQL Server Access | Inbound & Outbound Port Configure.

How To Configure 0:05:08

How To Configure SQL Server To Accept Remote Connections - SQL Server 2012, 2014, 2016

Windows Firewall Configuration 0:06:45

Windows Firewall Configuration For SQL Server to allow remote connection

How to configure 0:02:57

How to configure a remote connection with Microsoft SQL Server

Allow remote connections 0:06:05

Allow remote connections to Microsoft SQL Server (connect c# app to remote sql server)

How to Enable 0:01:56

How to Enable Remote Connections to SQL Server using IP address | Allowing Remote Access to Database

Import SQL Data 0:32:13

Import SQL Data into Power BI in 2024: Easy Step-by-Step Guide | Power Bi tutorial for beginners

Fix Windows Firewall 0:00:41

Fix Windows Firewall Warning While Installing SQL Server

How to Enable 0:02:51

How to Enable SQL Server 2017 Express TCP/IP Connection on Windows 10

How to access 0:08:00

How to access sql server from another computer

Allow remote connections 0:07:36

Allow remote connections to SQL Server Express : How to Video

Quick Tutorial - 0:10:54

Quick Tutorial - Users and Permissions in SQL Server

How to enable 0:04:36

How to enable SQL port 1433 easy Steps | Enable network access in SQL Server Configuration Manager

How to Configure 0:12:05

How to Configure MS SQL Failover Cluster in MS SQL Server 2019 - Step by Step

Enable SQL Server 0:02:21

Enable SQL Server Authentication

Set Windows Firewall 0:00:51

Set Windows Firewall to allow port 1433 (SQL) connections (inbound and outbound)

Connect SQL Server 0:08:48

Connect SQL Server from client computer

How to Fix 0:01:05

How to Fix SQL Cannot Connect Error in SQL Server Management Studio

How To Fix 0:05:27

How To Fix Network related or instance specific error occurred while establishing a conn SQL Server

How to enable 0:04:46

How to enable SQL authentication in Microsoft SQL Server 2019

Allow remote connectivity 0:05:19

Allow remote connectivity to SQL Server Database of Virtual Machine in windows | Access remotely

Give Permission to 0:02:15

Give Permission to SQL User in SQL Server using SSMS on database