I'm still trying to get a remote access to the MS SQL Server on one of my Windows machine.
I allowed the access on my Windows firewall as can be seen here and here. I also opened the port on CoMoDo FW as can be seen here.
But trying to access the machine from the Linux with busybox telnet 192.168.1.4 1433
does not produce "Connected".
The server itself does configured to accept the remote connections.
What other settings I'm missing?
Thank you.
[EDIT]
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 .
[/EDIT]
[EDIT2]
SQL Server listens on 1433 as can be seen here
[/EDIT2]
netsh advfirewall firewall add rule name="Allow SSMS Database Engine connections inbound on TCP 1433" dir=in action=allow protocol=TCP localport=1433 profile=domain,private
... If you need PUBLIC then changeprofile=domain,private
to beprofile=domain,private,public
as well for both commandsnetsh advfirewall firewall add rule name="Microsoft SQL Server 2014 Database Engine Access" dir=in action=allow program="C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe" enable=yes profile=domain,private