![努力让 MS SQL 远程访问发挥作用](https://linux22.com/image/1501098/%E5%8A%AA%E5%8A%9B%E8%AE%A9%20MS%20SQL%20%E8%BF%9C%E7%A8%8B%E8%AE%BF%E9%97%AE%E5%8F%91%E6%8C%A5%E4%BD%9C%E7%94%A8.png)
我仍在尝试在我的其中一台 Windows 机器上获取对 MS SQL Server 的远程访问。
我允许 Windows 防火墙进行访问,如下所示这里和这里。我还打开了 CoMoDo FW 上的端口,如下图所示这里。
但是尝试从 Linux 访问该机器时并busybox telnet 192.168.1.4 1433
没有产生“连接”。
服务器本身确实配置为接受远程连接。
我还缺少哪些设置?
谢谢。
[编辑]
C:\Users\Igor>netsh firewall add allowedprogram program="C:\Program Files\Micros
oft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" name="Microsoft SQL
Server 2012 Database Engine Access" profile=domain,private
The syntax supplied for this command is not valid. Check help for the correct sy
ntax.
add allowedprogram
[ program = ] path
[ name = ] name
[ [ mode = ] ENABLE|DISABLE
[ scope = ] ALL|SUBNET|CUSTOM
[ addresses = ] addresses
[ profile = ] CURRENT|DOMAIN|STANDARD|ALL ]
Adds firewall allowed program configuration.
Parameters:
program - Program path and file name.
name - Program name.
mode - Program mode (optional).
ENABLE - Allow through firewall (default).
DISABLE - Do not allow through firewall.
scope - Program scope (optional).
ALL - Allow all traffic through firewall (default).
SUBNET - Allow only local network (subnet) traffic through firewall.
CUSTOM - Allow only specified traffic through firewall.
addresses - Custom scope addresses (optional).
This comma-separated scope can contain IPv4 addresses,
IPv6 addresses, subnets, ranges, or the keyword LocalSubnet.
profile - Configuration profile (optional).
CURRENT - Applies to the active profile. Active profile can be domain,
standard (i.e. private), or public. (default).
DOMAIN - Applies to the domain profile.
STANDARD - Applies to the standard (i.e. private) profile.
ALL - Applies to the domain and standard (i.e. private) profile.
Does not apply to the public profile.
Remarks: 'scope' must be 'CUSTOM' to specify 'addresses'.
`addresses' can not contain Unspecified or Loopback addresses.
Examples:
add allowedprogram C:\MyApp\MyApp.exe "My Application" ENABLE
add allowedprogram C:\MyApp\MyApp.exe "My Application" ENABLE CUSTOM
157.60.0.1,172.16.0.0/16,10.0.0.0/255.0.0.0,
12AB:0000:0000:CD30::/60,LocalSubnet
add allowedprogram program=C:\MyApp\MyApp.exe name="My Application"
mode=DISABLE
add allowedprogram program=C:\MyApp\MyApp.exe name="My Application"
mode=ENABLE scope=CUSTOM addresses=157.60.0.1,
172.16.0.0/16,10.0.0.0/255.0.0.0,
12AB:0000:0000:CD30::/60,LocalSubnet
IMPORTANT: "netsh firewall" is deprecated;
use "netsh advfirewall firewall" instead.
For more information on using "netsh advfirewall firewall" commands
instead of "netsh firewall", see KB article 947709
at http://go.microsoft.com/fwlink/?linkid=121488 .
[/编辑]
[编辑2]
从中可以看出,SQL Server 监听 1433这里
[/编辑2]