It is also assumed that you have configured SQL Server for remote access, either manually, or by following the steps in How To: Configure SQL Server for Remote Access. Other Firewalls may have similar settings that can be applied. This article only applies to Windows Defender Firewall. To follow the steps in this document you will need to have one of the versions of SQL Server running on one of the versions of Windows mentioned above.
Microsoft SQL Server Express/Standard or higher editions 2012 or later.This document will show you how to open remote access to SQL Server by configuring Windows Firewall. We focus this guide on Command Prompt, but you can use the same commands to manage the remote desktop protocol using PowerShell.How To: Configure Windows Firewall for SQL Server (Optional) Type the following command to disable remote desktop through the Windows Firewall and press Enter: netsh advfirewall firewall set rule group="remote desktop" new enable=NoĪfter you complete the steps, the Remote Desktop service will be disabled, and the Windows Firewall port will be closed. Type the following command to disable the remote desktop protocol and press Enter: reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server" /v fDenyTSConnections /t REG_DWORD /d 1 /f To disable the remote desktop protocol with Command Prompt, use these steps: Disable Remote Desktop using Command Prompt Once you complete the steps, the protocol will enable on Windows 10, and you will be able to access the device remotely. (Optional) Type the following command to enable remote desktop through the Windows Firewall and press Enter: netsh advfirewall firewall set rule group="remote desktop" new enable=Yes
Type the following command to enable the remote desktop protocol and press Enter: reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server" /v fDenyTSConnections /t REG_DWORD /d 0 /f Search for Command Prompt, right-click the top result, and select the Run as administrator option. To enable the remote desktop protocol with Command Prompt, use these steps: Enable Remote Desktop using Command Prompt It is also recommended you create a full backup of your computer before proceeding, as modifying the registry can cause irreversible damage to your system. It is only on Windows 10 Pro, Enterprise, and Education. Important: Remote Desktop is not a feature available on Windows 10 Home.
0 kommentar(er)
