> For the complete documentation index, see [llms.txt](https://micro8.gitbook.io/micro8/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://micro8.gitbook.io/micro8/contents-1/1-10/7sqlserver-chang-yong-cao-zuo-yuan-cheng-zhuo-mian-yu-ju.md).

# 第七课：sql server 常用操作远程桌面语句

## 1、是否开启远程桌面

* 1：表示关闭
* 0：表示开启

  ```sql
  EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
  'SYSTEM\CurrentControlSet\Control\Terminal Server',
  'fDenyTSConnections'
  ```

  ![](/files/-LZJwqMexdMi1cQLZUbN)

## 2、读取远程桌面端口

```sql
EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TerminalServer\WinStations\RDP-Tcp',
'PortNumber'
```

![](/files/-LZJwqMg5E64P5jwiuhC)

## 3、开启远程桌面

```sql
EXEC master.dbo.xp_regwrite'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TerminalServer',
'fDenyTSConnections','REG_DWORD',0;
```

**reg 文件开启远程桌面：**

```
Windows Registry Editor Version 5.00HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TerminalServer]
"fDenyTSConnections"=dword:00000000[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TerminalServer\WinStations\RDP-Tcp]
"PortNumber"=dword:00000d3d
```

//// 保存 micropoor.reg，并执行 regedit /s micropoor.reg

**注：如果第一次开启远程桌面，部分需要配置防火墙规则允许远程端口。**

```bash
netsh advfirewall firewall add rule name="Remote Desktop" protocol=TCP
dir=in localport=3389 action=allow
```

## 4、关闭远程桌面

```sql
EXEC master.dbo.xp_regwrite'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TerminalServer',
'fDenyTSConnections','REG_DWORD',1;
```

\--By Micropoor