How to allow remote connections to MS SQL EXPRESS 2008?

Question

SQL Server

Please point out the mistake.
Unable to allow remote connections to the SQL EXPRESS 2008 server
The following was done:
in the properties of the server in management studio, on the connection tab, the "Allow remote connections" switch was checked
in the SQL Configuration manager enabled tcp ip

spoiler

Allowed in the firewall ports 1433 tcp and udp
port 1433 listens in the system. checked with netstat -a

Answer 1

Select protocols for the server and not for the client. You also need to connect to
192.168.1.1\SQLExpress
, that is, specify not only the ip of the machine, but also the name of the instance

Answer 2

It is unlikely that anyone outside will be able to reach the ip4 address 127.0.0.1 indicated on the screen

Answer 3

you have a local address, Ipv4 ... write down the real one, which is issued to the network

Answer 4

Must turn on

above there is an external address with a similar setting

And there too.

Allowed ports 1433 tcp and udp in the firewall

Allow Application