Topic: Access to MS a SQL server express through the Internet.
It was required to me to get somehow access to house MS SQL Server Express 2016 through the Internet.
The circuit of a house network the such: there is ZyXEL Keenetic router (FW v.2) which lifts session PPPoE and distributes an Internet through and . The computer on which it is twisted SQL the server (192.168.1.2) is connected To a router on .
That I made:
Included in the server TCP/IP protocol and adjusted ports. In broad gulls received following :
Server is listening on [' any ' <ipv6> 11433].
Server is listening on [' any ' <ipv4> 11433].
Server is listening on [' any ' <ipv6> 53250].
Server is listening on [' any ' <ipv4> 53250].
Server local connection provider is ready to accept connection on [\. \PIPE\SQLLOCAL\SQLEXPRESS].
Server local connection provider is ready to accept connection on [\\.\pipe\MSSQL$SQLEXPRESS\sql\query].
11433 is a static port.
53250 - dynamic.
On a router it is lifted dynamic NAME.ddns.net. It is adjusted ports:
Network The Source address Port Assignment Port of destination The Description
PPPoE0 tcp/1433 192.168.1.2 11433 MSSQL
PPPoE0 udp/1433 192.168.1.2 11433 MSSQL (UDP)
PPPoE0 tcp/53250 192.168.1.2 53250 MSSQL_53250
PPPoE0 udp/53250 192.168.1.2 53250 MSSQL_53250 (UDP)
Opened ports in a firewall.
The scanner of ports, shows that the port is opened, on a domain name - transits, the web a muzzle through the Internet - rises.
I try clings to SQL from the remote computer, produces the code 0 . From the local computer, at that line of connection, incorporates. The firewall in OS - is ungeared.
Line of connection: NAME.ddns.net \SQLEXPRESS, 11433
What do I do not and how to correct?