SQL Server database not reachable over network

 What

Configure SQL server database to be reachable over the network

 Problem

I installed a completely new SQL server, but I couldn't connect to the database over the network!

 Solution

When you install a brand new SQL server, de default option is that the tcp/ip is not enabled for a new database. That's why you can't connect to it from another computer.

To enable this you first have to got to the SQL Server Configuration Manager Click start and go to your installed SQL server, configuration tools and finally there you'll find the manager.

When the manager is opened you have tho enable the tcp/ip  for your database. In this example our database is named POS. Right click on the tcp/ip and select enable.

After that you have to restart the POS instance, as follows:

When I did this, I wasn't still not able to connect to the database, I check that my firewall was disabled on workstation and server. But still couldn't make the connection. Then I configured the port the SQL Instance for POS should listen to in port 1433.

You can configure this setting, go back to the protocols for POS and right click tcp/ip and select properties. Their on the Ip addresses tab we can set the port:

Finally restart again the POS Instance and everything will guarantee work!