1

Я все еще пытаюсь получить удаленный доступ к MS SQL Server на одном из моих компьютеров с Windows.

Я разрешил доступ на своем брандмауэре 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 .

[/РЕДАКТИРОВАТЬ]

[EDIT2]

SQL Server прослушивает 1433, как можно увидеть здесь

[/EDIT2]

|источник

0