努力让 MS SQL 远程访问发挥作用

努力让 MS SQL 远程访问发挥作用

我仍在尝试在我的其中一台 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]

相关内容